The VBA-Tanker is a Tool with a lot of VBA-Macros and programming examples. Go to example page
Sophisticated search functions and a professional interface can be used to find the desired procedure in a matter of seconds. The contents of the database come primarily from our projects, books, newsletters, articles and lectures. These are field-tested VBA solutions and code snippets.
The “VBA tanker” does not require installation and can easily be taken with you on a USB stick and used anywhere. If required, the database can be synchronized with the database stored on the Internet daily or at any time . Sample files for free download are also available on the Internet.
- 4.000 free macros with examples
- 30 years of VBA-experience from projects, own books, articles and training sessions
- save your own VBA-examples in this database
- Free VBA support
TOC: Last update: 01-17-2023
ID Title
1 How to color chartobject columns by value
2 How to scale chartobject by max-value+10%
3 How to select all shapes in sheet
4 How to move charts to new sheet
5 How to move chartobject to new sheet
6 How to determine new position of chartobject and resize it
7 How to determine new position of chartobject
8 How to read all values from chart --> Sheet2
9 How to apply data labels from row 2
10 How to insert custom chart label
11 How to hide and show chartobject
12 How to remove all chartobjects in sheets
13 How to remove all charts in workbook
14 How to insert chartobject in Sheet1
15 How to create chart based on current region of cell B2
16 How to create chart based on namend range
17 How to create chart and show title
18 How to set your own format style (Arial, fontsize 25)
19 How to set your own format style based on a formatted cell
20 How to delete all custom format
21 How to search for a custom list
22 How to create custom list from Array
23 How to create custom list from sheet1
24 How to delete all custom list in application
25 How to delete all comments in workbook
26 How to delete all shapes in workbook
27 How to search text in whole workbook
28 How to list and link all files in folder
29 How to update all external links to other workbooks
30 How to kill all external links in workbook (freeze links to values)
31 How to kill external links in sheet1
32 How to kill all links to other workbooks
33 How to search for special link in workbook
34 How to list links to other workbooks in VBE
35 How to list links to other workbooks in sheet
36 How to get info about actual file
37 How to set own document property "Waranty"
38 How to get creation date & last update
39 How to list all document properties
40 How to print all sheets in workbook (only page 1)
41 How to print whole workbook
42 How to add Workbooks based on Column "A" in sheet1
43 How to add new workbook with one sheet
44 How to close and save active workbook after 2 minutes
45 How to close all open workbooks up to the actual workbook
46 How to close and save workbook with last access documentation
47 How to show dialog File open
48 How to open latest file in a folder
49 How to list all open workbooks in a new sheet
50 How to customize recent files list to 8 entries
51 How to save actual workbook as date & time stamp
52 How to save all Sheets in individual text files
53 How to determine path of workbook
54 How to create folder …\Backup
55 How to insert/remove picure to background of sheet
56 How to display dialog to insert picture in sheet
57 How to insert picture in all sheets in cell B10
58 How to insert picture and duplicate it
59 How to create table with links to sheets
60 How to activate sheet by sheet (all 2 seconds)
61 How to uncolor all tabs
62 How to color all tabs of a workbook
63 How to show/hide worksheet tabs
64 How to copy all data of sheets in one sheet
65 How to write Sheet to text file
66 How to copy activesheet at the end of workbook with time stamp
67 How to check, if Sheet2 exist
68 How to sort sheets by name
69 How to determine selected sheets
70 How to copy active sheet to another workbook
71 How to copy Sheet1 to new workbook (only values)
72 How to move Sheet1 to the end
73 How to export selected sheets in new workbooks
74 How to name worksheets (both names sheets)
75 How to determine page numbers
76 How to set printarea to current region of cell D7
77 How to set printarea to used range
78 How to set printarea to range
79 How to insert footer with 3 rows (creation date, last update and author)
80 How to insert footer with document properties (company and author) and a logo
81 How to insert footer with document properties (company and author)
82 How to insert header with formatted date
83 How to insert footer with Path/ Name of workbook and username
84 How to hide all sheets with exception of activeSheet
85 How to show all hidden sheets
86 How to hide / show Sheet1 (very hidden)
87 How to hide / show Sheet1
88 How to protect Sheet1, allow AutoFilter and outline
89 How to protect Sheet1, allow AutoFilter
90 How to protect all formulas in active sheet
91 How to clear all not locked cells
92 How to protect sheet, allowa few things
93 How to activate previous sheet / Activate next sheet
94 How to delete all sheets up to Sheet1
95 How to delete active sheet without query
96 How to name sheets with date and username
97 How to name sheets with date
98 How to group sheets after Sheet1
99 How to group Sheet1 and Sheet3
100 How to color several ranges
101 How to fill Cells In Intersection
102 How to fill different cells
103 How to combine Selection
104 How to set link to other sheet
105 How to check if cell A1 is empty
106 How to get data from internet
107 How to determine used cells in active row
108 How to set reference to other cell
109 How to select all/used cells in sheet
110 How to check if active cell is in Area A1:D10
111 How to format font (Selection)
112 How to clear contents with red font
113 How to color first tree characters
114 How to transfer format from Range to range
115 How to insert special character in cell
116 How to write chemical formula
117 How to format border around cells
118 How to transfer border format only
119 How to set numberformat for columns
120 How to write a formatted date
121 How to clear all formats in range
122 How to transfer only format from one range to another range
123 How to insert conditional format
124 How to insert random numbers as matrix formula
125 How to change cell color in whole sheet
126 How to use formula and write it as value
127 How to use formula CountIf in macro
128 How to use formula SumIf and write it as value
129 How to use formula Vlookup and write it as value
130 How to find smallest values in a sheet
131 How to find largest values in a sheet
132 How to calculate average from the 5 largest numbers
133 How to round numbers
134 How to list all colorindex in a sheet
135 How to convert all formulas to absolute/relative
136 How to look for special characters in cell
137 How to remove all blanks in cells
138 How to remove special characters out of cells
139 How to replace special character to another character
140 How to cut text to 3 characters
141 How to extract first two and last two characters
142 How to remove last character from selected cells
143 How to fill leading zeros to selected cells
144 How to clear all values, keep formulas
145 How to remove numbers from selected cells
146 How to remove alphanumeric characters from selected cells
147 How to remove empty cells in Selection
148 How to clear all numbers, not date, not formula and not text
149 How to extract name of workbook from path
150 How to change position of names
151 How to select all cells with validation
152 How to insert validation rule (numbers from 1 to 100)
153 How to insert validation rule (date)
154 How to insert validation rule (Date without sundays)
155 How to clear all validation rule in sheet
156 How to use inputbox to write a comment
157 How to update an existing comment
158 How to select all comments in sheet
159 How to clear all comments in sheet
160 How to list comments (Two examples)
161 How to put cell value to comment
162 How to format all comments in sheet
163 How to format all comments in this workbook
164 How to use AutoSize function for all comments in sheet
165 How to count words in selected cells
166 How to find first empty cell in range
167 How to insert shape and fill it
168 How to manage position of inserted shape
169 How to list all shapes in sheet
170 How to check, if a shape is in range?
171 How to count all cells with negative values
172 How to select several rows/columns
173 How to select columns A to C
174 How to determine kind of selection
175 How to count filled cells in range
176 How to define Columnwidth for Column A to E
177 How to define Rowheight für rows 1-4
178 How to use AutoFit for columns
179 How to insert Columns and Rows
180 How to insert cells and shift selection
181 How to insert row before cell with "sum:"
182 How to search for "sum" and insert new row after..
183 How to delete rows and columns
184 How to delete numeric rows with incorrect lenght
185 How to delete rows in selection with zero or blank
186 How to delete really empty rows
187 How to delete rows if date in Column A < B1
188 How to delete all hidden rows
189 How to hide/show empty rows
190 How to hide rows with indentLevel=1
191 How to delete rows with double numbers
192 How to delete rows by doubleclick
193 How to clear data without titles
194 How to find cell with actual date
195 How to color every second row in selection
196 How to color every second column in selection
197 How to sort data by nr and amount
198 How to write every third value to column B
199 How to compare two columns and write the higher value to Column C
200 How to color all weekends in columns
201 How to wrap text in Selection
202 How to print title rows/columns
203 How to search for name in Column
204 How to activate AutoFilter
205 How to reset AutoFilter
206 How to reset AutoFilter (all sheets)
207 How to apply Autofilter value<100
208 How to apply Autofilter between 50 and 100
209 How to apply Autofilter between 50 and 100 (criteria based an cell)
210 How to use AutoFilter with date
211 How to determine the filtered columns
212 How to count filtered rows
213 How to determine max-value in filtered column B
214 How to determine first filtered row
215 How to determine last filtered row
216 How to use advanced filter to get list with no duplicates
217 How to save conditional rows in text file
218 How to copy usedrange to Sheet2
219 How to transfer usedrange of Sheet1 to Sheet2 without copy
220 How to write cells and cut them
221 How to get new prices from Sheet2
222 How to find min and max values in a range
223 How to insert header with username, creation date, actual date and name/path of file
224 How to protect all sheets in file (allow formatting cells)
225 How to convert data (force Excel to recognize values
226 How to convert data (Minus wrong position)
227 How to convert data (date in uniform format)
228 How to convert data (insert leading zero)
229 How to convert data (Change number to name)
230 How to insert new worksheet at the beginning/at the end of workbook
231 How to format chart legend
232 How to insert textfield in chartobject
233 How to create pivot-Table
234 How to refresh Pivot-Table
235 How to refresh all Pivot-Tables in Sheet2
236 How to refresh all Pivot-Tables in active workbook
237 How to expand range of Pivottable and refresh all Pivottables in Sheet2
238 How to expand range of Pivottable and refresh all Pivottables in Sheet2
239 How to sort Pivot-Table by name (Desc)
240 How to format Pivot-Table
241 How to read actual page-field of a pivot table
242 How to set page field to "all"
243 How to set page field to cell H1
244 How to get name/pathname of workbook
245 How to move custom functions to own category
246 How to check if a sheet is empty
247 How to check protection mode of sheets
248 How to check if a column is empty
249 How to convert numbers to text
250 How to check if a cell has a formula
251 How to check if a cell contains validation rule
252 How to check if a cell has a comment
253 How to check, if a range has merged cells
254 How to remove zeros out of cells
255 How to make initials from names
256 How to write formula text
257 How to count bold cells
258 How to sum colored cells
259 How to count colored cells
260 How to calculate time in minutes
261 How to calculate minutes in hours
262 How to check, if a cell contains a Hyperlink
263 How to round a number to 05 cent
264 How to get numberformat from cell
265 How to calculate miles per hour
266 How to count numbers in a string
267 How to convert roman characters in arabic characters
268 How to determine number of files in folder
269 How to check existence of a file
270 How to check if a workbook is open
271 How to get document properties from a closed file
272 How to determine, if a day is a workday
273 How to get last day of month
274 How to create a scrollArea
275 How to define window-settings
276 How to close and save a workbook
277 How to write last change during saving a workbook
278 How to sort data before saving a workbook
279 How to print a worksheet
280 How to insert a worksheet
281 How to count every printout in cell A1
282 How to prevent a user to activate a worksheet
283 How to start calculating a worksheet after activating sheet
284 How to play battleship
285 How to compare two columns
286 How to deal with changes in a certain range
287 How to color changes in a certain range automatically
288 How to use function AutoFit
289 How to monitore cells
290 How to check if an input is in a given range
291 How to react on an input in cell A1
292 How to set cursor after input
293 How to mirror input from ione sheet to another
294 How to color a cell after input
295 How to keep old value after an input
296 How to prevent double inputs in Column A
297 How to enlarge font size of active cell
298 How to select single cell --> selection whole row
299 How to prevent selecting a certain cell
300 How to cancel input in a given cell
301 How to disable right click in a given range
302 How to increment cell value after double click
303 How to show MsgBox after PivotTabel update
304 How to wrap text in a cell
305 How to insert text in cell with multiline
306 How to activate/deactivate context menu in worksheet tab
307 How to make a countdown
308 How to close all open workbooks and close excel
309 How to play sound in Excel
310 How to create flashing cell in Excel
311 How to integrate a reference in VBE
312 How to activate Visual basic for Application Extensiblity library
313 "How to list library info in immediate window"
314 How to call VBE window
315 How to disable shortcut Alt+F11 to get to the VBE
316 How to add/delete (new) module in VBE
317 How to delete a procedure
318 How to delete alle procedures in a workbook
319 How to import procedure from text file
320 How to export a module in a text file
321 How wor copy a modle into a new workbook
322 How to list all vbcomponentes in immediate window
323 How to determine excel version
324 How to use MsgBox as query before clearing cells
325 How to show flash screen during opening workbook
326 How to use InputBox to select a range
327 How to show/close an userform
328 How to show userform (modeless) and close userform
329 How to show userform (modeless) and close userform
330 How to show userform (modeless) and close userform
331 How to check, if input in TextBox1 is a numeric value
332 How to check, if input in TextBox1 is a date
333 How to check, if input in TextBox1 is a numeric value
334 How to hide/show TextBox by click to checkbox
335 How to enter password in textbox
336 How to show userform with random colors
337 How to fill a listbox with name of sheets
338 How to add entries to a listbox and react to click
339 How to select last/first entry in a listbox
340 How to use ToggleButton to select all entries in a listbox
341 How to get entries for the listbox from Sheet1
342 How to fill a listbox with several columns
343 How to add month names in a combobox
344 How to use property "RowSource" to link entries in sheet1
345 How to force user to select only definded names in a combobox
346 How to combine SpinButton with TextBox
347 How to create your own progressBar
348 How to start userform by doubleclick in column A
349 How to insert button in every sheet
350 How to insert button (with picture)
351 How to try to cklick a button (-;
352 How to show/hide gridlines
353 How to show/hide a shape
354 How to insert a shape by condition
355 How to reset all ToggleButtons in a sheet
356 How to fill TextBoxes in a sheet
357 How to put text from cell to TextBox
358 How to fill several textboxes from cells
359 How to Connect Combobox with range
360 How to fill comboBox with named range
361 How to sort combobox by name
362 How to fill combobox with ordered entries
363 How to insert combobox at runtime
364 How to assign cell to checkbox caption
365 How to label checkboxes from cells
366 How to check if a worksheet is protected
367 How to count all hyperlinks in a sheet
368 How to enable contextmenu
369 How to clean cells from not printable
370 How to create your own cell contextmenu
371 How to transfer excel cells to new word document
372 How to list all procedures to a new word-Document
373 How to send E-Mail with attachments from a folder
374 How to transfer contacts to outlook
375 How to import contacts from outlook
376 How to determine / reset printarea
377 How to create a unique list
378 How to find and color external links to other workbooks
379 How to calculate difference between actual day to day in past
380 How to disable drag&drop
381 How to rename image-files in a folder
382 How to list all files in folder
383 How to create desktop link to this workbook
384 How to change External links to values
385 How to use scrollbars (yellow cell goes to left, upper corner
386 How to insert textfile as object
387 How to label windows caption
388 How to insert comboboxes and link to data
389 How to undo all input in a column
390 How to display gridlines in every sheet
391 How to align chartobject to cell
392 How to fill an array with weekdays
393 How to declare a fixed Array, fill it and use loop to go throught it
394 How to label axes of chartobject
395 How to modify chart style
396 How to comment a named range
397 How to copy Excel range to Powerpoint slide
398 How to print several sheets at once
399 How to check, i a workbook is a AddIn
400 How to delete all named ranges in workbook
401 How to hide/show names in Excel
402 How to check if a named range is in selection
403 How to create a dynamic named range
404 How to set name based on a given area
405 How to check if a named range is in a workbook
406 How to write a value in a named range
407 How to add name based on a title
408 How to format dates of last weeks
409 How to insert autoshapes in a worksheet
410 How to insert shape with text effect
411 How to insert textbox in sheet
412 How to use method pastespecial
413 How to check reference style
414 How to search for a unique number in column
415 How to find a unique number in a range
416 How to find multiple numbers in a range
417 How to detect max value(s) in a range
418 How to find zeros in a range
419 How to count all files/only excel files in a folder
420 How to write Sheet in Array and export to text file "Output.txt"
421 How to color cells after input automatically
422 How to enter same comment in all selected cells
423 How to update existing comments
424 How to format all comments in a worksheet
425 How to format all comments in a workbook
426 How to delete comments in a worksheet
427 How to delete all comments in workbook
428 How to remove all comments from person XXX in active workbook
429 How to show dialog open
430 How to use shortcuts in an userform
431 How to open empty E-Mail after cklick to image control in userform
432 How to show windows info screen with additional text
433 How to start a not movable userform
434 How to prevent closing userform by clicking red cross icon
435 How to set focus on the first textbox in userform
436 How to align all text in textboxes to the right
437 How to write actucal date to textbox1 and select input
438 How to color active textbox and take color away by leaving textbox
439 How to get to the internet by clicking a label
440 How to use AutoFill function for textbox
441 How to determine position of a shape
442 How to determine width and height of all shapes in sheet (outout to immediate window)
443 How to increase/decrease all shapes in sheet
444 How to insert shape and identify it
445 How to insert autoform after input of a number greater 100
446 How to insert a workbook event by vba macro
447 How to change text in Macro via other macro
448 How to read macro and output to MsgBox
449 How to display full screen
450 How to display workbook tabs ON/OFF
451 How to display headings
452 How to display gridines
453 How to list all environ variables in sheet
454 How to add chart and link data
455 How to add chartobject to sheet and link to data
456 How to Show extreme values in chartobject
457 How to add tiny charts to sheet
458 How to add your own sparkline to sheet
459 How to hide double numbers in column A
460 How to hide duplicate data in Column A and output to Column H
461 How to show all hidden data
462 How to create userform during runtime of macro
463 How to get drive of actual workbook
464 How to add new folder to users desktop
465 How to get for the filename of the actual file without extension
466 How to check existence of drive, folder and file
467 How to rename several files
468 How to determine Office installation folder
469 How to determine default file path to save workbooks
470 How to determine startup Folder of excel
471 How to determine alternativie startup Folder of excel
472 How to set overwrite alerts (Drag & Drop)
473 How to set link alert on/off
474 How to add entry to AutoCorrection
475 How to list all autocorrect entries
476 How to set hyperlink formatting on/off
477 How to set calculation in Excel on/off
478 How to determine which button is clicked
479 How to empty clipboard after copy
480 How to get/set country settings
481 How to get/set default save format
482 How to show comment indicator
483 How to display/hide statusbar
484 How to display/hide formula bar
485 How to list recent files in sheet1
486 How to clear recent files list
487 How to get recent files list (pathname + filename)
488 How to set "Edit directly in cell"
489 How to enable/disable AutoComplete
490 How to get actual size of window
491 How to set cursor move after return
492 How to get name and nr of the window version
493 How to get/set standard font name and font size
494 How to save actual workbook and quit Excel
495 How to set standard Chart Type
496 How to interrupt a macro for a few seconds
497 How to create a custom list
498 How to get AutoRecovery settings
499 How to check, if vba project has a vba sign
500 How to call a internet site
501 How to close active workbook without saving
502 How to save actual workbook with date and time stamp
503 How to export all comments from Sheet1 in textfile "comments.txt"
504 How to check the existence pf "Personal.xlsb"
505 How to write last saved time in cell A1
506 How to change first color of color palette
507 How to switch on calculation before saving this file
508 How to check if active workbook is opened "read only"
509 How to clear all Headers and footers in every sheet
510 How to copy workbook onto desktop
511 How to delete a file
512 How to format textbox by leaving textbox
513 How to take range A1:G1, transpose it and assign to ListBox
514 How to enter only numeric digits in TextBox
515 How to define a multiline TextBox
516 How to color all labels in a Userform
517 How to change font and size for all labels in a Userform
518 How to synchronize two Textboxes in a userform
519 How to identify selected items in ListBox
520 How to insert picture with help of a dialog
521 How to navigate to first page of Multipage and write TextBoxes in pages
522 How to navigate to first page of Multipage and write TextBoxes in pages
523 How to get caption of labels from a sheet
524 How to link a TextBox with a listBox (show selected entry from Listbox in Textbox)
525 How to open all selected workbooks in dialog
526 How to start Internet explorer by click a button in a userform
527 How to accept only numeric digits in a TextBox
528 How to use a checkBox to Hide / show Textboxes in a userform
529 How to use a checkBox to enlarge / shrink the Height of a userform
530 How to show listbox in a userform with column headers
531 How to close a userform in 3 seconds after cklick a button
532 How to respond on right or left mouse click in a listbox
533 How to show last date / amount in sheet to textboxes of a userform
534 How to play music during start of an userform
535 How to convert input in a range to upper case characters
536 How to to get the character "X" after doubleclick in column A
537 How to color cell after doubleclick
538 How to protect entries in Column A without sheet protection
539 How to protect titles in a worksheet
540 How to synchronize changes in Range A1:A10
541 How to prevent cutting cells
542 How to cancel printing with an event
543 How to list all changes in one sheet
544 How to remove all worksheet events from sheet1
545 How to fullsize window after open this file
546 How to color active row
547 How to react on input in first column
548 How to send an E-Mail with API-Function
549 How to get windows folder name
550 How to get windows system folder
551 How to determine the application of a file
552 How to show folder dialog (API)
553 How to determine drive type (API)
554 How to get width and Height from Screen (API)
555 How to get free disk space (API)
556 How to get username (API)
557 How to set actual folder (API)
558 How to get actual cursor position
559 How to take a break for a few seconds (API)
560 How to open and close CDROM drive (API)
561 How to play a sound (API)
562 How to clear clipboard (API)
563 How to get computername (API)
564 How to convert a text to upper or lower letters (API)
565 How to get system date and time (API)
566 How to get status of an application (API)
567 How to read filter criteria
568 How to create directory (API)
569 How to play track on CD (API)
570 How to convert values with decimals in int numbers (cutting)
571 How to use function to get the quarter of a date
572 How to use function to get weekday of a date
573 How to check, if the actual day is even or odd
574 How to use worksheetfunction VLOOKUP (value)
575 How to use worksheetfunction VLOOKUP (as formula)
576 How to show important subtotals
577 How to count how often a given character is in a range
578 How to shorten a long pathname (API)
579 How to check if a range is empty
580 How to insert copyright sign
581 How to get your standard printer
582 How to start PowerPoint with one command
583 How to start Outlook with one command
584 How to list all files in folder
585 How to insert button and link to macro
586 How to delete last inserted chartobject
587 How to export chartobject as GIF
588 How to export chart as GIF
589 How to call windows char map
590 How to read chart formula
591 How to insert rectangle and adjust to given range
592 How to insert line and format it
593 How to copy a file from on folder to another folder
594 How to measure duration of macro
595 How to format plotarea of chartobject
596 How to format lines in Chartobject
597 How to generate random letter
598 How to freeze window
599 How to freeze chartobjects formulas
600 How to start windows notepad.exe
601 How to insert desktop shortcut with link to folder
602 How to start windows explorer
603 How to start word with new document
604 How to show PDF file in internet explorer
605 How to List structure of folders
606 How to get actual folder
607 How to get codes with function Chr
608 How to start PowerPoint, insert new presenation and slide
609 How to get the alphabet in Sheet1
610 How to delete columns C:E
611 How to determine last column in selection
612 How to determine first column in selection
613 How to clear blanks in every used cell in Column A
614 How to find actual date in Column A
615 How to fill formulas from row 2 to to down
616 How to set numberformat Columns A:C
617 How to hide every second column
618 How to allow only numbers in column A
619 How to delete all Hyperlinks in active sheet
620 How to create a table of contents with all sheets from active workbook
621 How to list all comments in sheets
622 How to refresh all QueryTables in Sheet
623 How to identify sheet by Property Type
624 How to get codename of worksheet "Start"
625 How to copy sheet at the end of the workbook
626 How to copy sheet to new workbook
627 How to call printPreview
628 How to insert/remove subtotals
629 How to print sheet directly or after printpreview
630 How to print sheet with gridlines
631 How to fill listbox without duplicates
632 How to delete all buttons in sheet
633 How to check existence of pivottables in active sheet
634 How to deactivate all togglebuttons in a sheet
635 How to fill combobox with all visible sheets
636 How to clear combobox in a worksheet
637 How to insert Textbox without border
638 How to set printtitle rows for all sheets
639 How to set zoom in all sheets to 80%
640 How to insert header with a line
641 How to format selection of cells with font properties
642 How to color first three characters for each cell in selection
643 How to insert symbol to active cell
644 How to write chemical formulas
645 How to insert smiley and link to macro
646 How to set important print settings
647 How to format font in whole sheet
648 How to write footer with smaller font size
649 How to show / hide all buttons in a sheet
650 How to show / hide all commandButtons in a sheet
651 How to insert sheets for the next 14 days
652 How to move a sheet to another position
653 How to show / hide all Textboxes in sheet
654 How to determine names and postions of all comboboxes in sheet
655 How to get name of shapes
656 How to make a copy of workbbooks without formulas
657 How to insert shapes and adjust them
658 How to write all formulas in textfile
659 How to insert Chart and hide region south
660 How to set papersize of sheet (A4)
661 How to format sheet as checkered block
662 How to format sheet as lined block
663 How to print only odd pages of a sheet
664 How to print a module
665 How to delete module via macro
666 How to change codename of sheet
667 How to delete a userform from workbook
668 How to find latest date in range
669 How to find earliest date in range
670 How to get sum of selected cells
671 How to transfer only numberformat to another column
672 How to insert formatted date in activecell
673 How to find all cells with SUM formula
674 How to fill array and transpose
675 How to color first two digits of every cell in selection
676 How to insert hyperlink to cell
677 How to set Quotation marks to cell text
678 How to set Borders (Top) to selected cells
679 How to find part of text in cell and color it
680 How to align text of selected cells vertically and horizontally
681 How to set text in higher/deeper position of all selected cells
682 How to reverse text in cells
683 How to fill cell with lenght < 10 with stars
684 How to add a validation list to selected cells
685 How to add a validation list to selected cells with reference to a range
686 How to add a validation list to selected cells with named range
687 How to determine first/last character of a cell
688 How to format every second character in selected cells
689 How to convert a number to text
690 How to calculate appointment (date + 3 month)
691 How to calculate calendar week of actual date
692 How to calculate differerence between two dates
693 How to convert date with function DateValue
694 How to extract parts of a date (day, month, year)
695 How to get last saved time of file
696 How to format a date with function FormatDateTime
697 How to extract monthname from actual date
698 How to determine quarter and weekday from actual date
699 How to remove letters out of a string
700 How to list characters of chr function in immediate window
701 How to add Address to an array, manipulate array and write it to immediate window
702 How to replace a character with another character
703 How to loop through a string character for character
704 How to remove blanks left and right from a string
705 How to list all files in a folder (with creation date of file)
706 How to read a text file row for row until end of file
707 How to read the first 10 characters out of a textfile
708 How to start notepad and open a textfile
709 How to determine the absulte value of a number (remove minus)
710 How to remove decimal numbers by cutting
711 How to show print dialog with arguments
712 How to get color from palette
713 How to show dialog open with default path
714 How to show dialog open with file and password
715 How to show dialog saveas with filename and actual date
716 How to get dialog SaveAs and evaluate name of workbook
717 How to get function wizard with sum formula
718 How to get available printers
719 How to show dialog Find with settings
720 How to color columns with weekend
721 How to get link address behind shapes
722 How to prevent Sheet1 from moving to an other position
723 How to prevent entering a range
724 How to get file- and pathname of actual file
725 How to search for characters strings in cells
726 How to set row height for selected cells
727 How to set zoom to selected cells
728 How to set alignment of textbox
729 How to set scrollArea to usedrange
730 How to set PrintArea to usedrange
731 How to search in several ranges
732 How to border a range with individual settings
733 How to get a text from an array
734 How to insert Spinbutton in sheet and link to cell
735 How to insert label in to sheet and label it
736 How to check if Shift is pressed (API)
737 How to get procedure names into sheet
738 How to insert word document as icon
739 How to get file attribute (read only or not)
740 How to create a PDF from a sheet
741 How to insert combobox with doubleclick in any cell
742 How to add a dropdown to selected cell
743 How to clear contents, formats, comments and clear all
744 How to use conditional formatting to color duplicate numbers
745 How to get a list with all days of actual month
746 How to add TextBox to userform a runtime of macro
747 How to create random data
748 How to insert random numbers to selected cells
749 How to round all selected cells
750 How to sort data in active sheet
751 How to insert listobject
752 How to read ListObject
753 How to remove last row from a listObject
754 How to determine row number of active cell in listobject
755 How to determine row/column of active cell in listobject
756 How to get all listobjects of active sheet
757 How to sort a listobject by name
758 How to use data filter in Listobject
759 How to enable/disable autofilter in listobject
760 How to remove listobject
761 How to insert rows and columns to listobject
762 How to select all formulas with result=alphanumeric
763 How to select all yellow cells in worksheet
764 How to select all formulas in sheet with result=numbers
765 How to use sumif to sum all costs of a product-number
766 How to freeze all formulas in sheet into values
767 How to clear contents of several areas in sheet
768 How to check the existence of sheet by codename
769 How to check the existence of sheet by normal name
770 How to choose folder with shell object
771 How to choose folder with filedialog folderpicker
772 How to split text based on a separator in an array
773 How to split text based on a separator in an array and convert text
774 How to compare two strings with function StrComp
775 How to delete file on request
776 How to insert picture and delete after 3 seconds
777 How to close file after a few seconds
778 How to sum colored cells by colorindex
779 How to check if active cell is in range A1:D10
780 How to check if Microsoft Word is open
781 How to check if an access database is open
782 How to check if Microsoft PowerPoint is opened
783 How to determine days of a month
784 How to create unique list with 3 sheets
785 How to count carriage return in active cell
786 How to save new workbook with macros
787 How to use SaveAs Dialog with object FileDialog
788 How to send eMail with signature and attachment
789 How to delete lines from textfile and export to another textfile
790 How to export a chart
791 How to start checkspelling function after right click to cell
792 How to transfer rows from one textfile to another textfile
793 How to transfer all modules in a new workbook
794 How to remove macros and userforms out of a workbook
795 How to import/export a module
796 How to remove modul from VBE
797 How to use event Textbox1_Change to respond to input
798 How to show a picture based on Cell A1
799 How to start a macro after click in cell A1
800 How to show userform maximized (API)
801 How to use conditional formatting with font "wingdings"
802 How to delete all validation rules in sheet
803 How to delete only validation rules with dropdowns in sheet
804 How to complete a leading zero to textbox
805 How to set autofilter mode
806 How to get label caption for labels in userform from a sheet
807 How to refresh numbering column A after enter name
808 How to add sheet and rename codename of sheet
809 How to minimize window when userform starts
810 How to get position of controls in userform from sheet
811 How to get info, if actual year is a leap year
812 How to close workbook if 30 sec. nothing happens
813 How to delete columns with certain title
814 How to hide columns with certain title
815 How to set pagebreaks
816 How to delete all pagebreaks in a sheet
817 How to set print area with named cells
818 How to prevent user form printing a sheet
819 How to use event BeforeSave to prevent user to save workbook
820 How to send a mail after saving workbook
821 How to control all changes in a sheet
822 How to export sheet into a new workbook
823 How to export all sheets into new workbooks
824 How to extract day and month from date
825 How to get unique list from two sheets and calculate sales
826 How to transfer checked data to another sheet
827 How to print sheet in black-and-white
828 How to check if a date has expired
829 How to use and control labels in a sheet
830 How to use advanced filter to count unique values
831 How to create pivot table with macro
832 How to export every second sheet to new workbook and save it
833 How to export only numeric named sheets in a new workbook
834 How to clear special characters from cells
835 How to documentate saving file in a hidden worksheet
836 How to use collection to create a unique list
837 How to start userform and activate first page in multipage
838 How to hide a column with toggleButton
839 How to use RGB function to color cells
840 How to export several sheets to PDF
841 How to navigate to a cell and scroll to to left upper corner
842 How to get country settings (Decimal separator / Thousands separator)
843 How to export chartobject to new PowerPoint presentation
844 How to show userform in full windows size mode
845 How to delete rows in a sheet if cell in column A is empty
846 How to delete rows in a sheet if whole row is empty
847 How to get birthday list from outlook contacts
848 How to change windows title with username and date+time
849 How to edit cell with macro despite of sheet protection
850 How to color several columns at once
851 How to use custom function to calculate date in future or past
852 How to put several textfiles together in one textfile
853 How to use an event to control all input in given area
854 How to use Autofilter with Textboxes in userform
855 How to replace a special character in a column with another character
856 How to enlarge content of validation list by entering validation cell
857 How to fill listbox and evaluate selection in listbox
858 How to use databars in conditional formatting
859 How to use conditional format "Above average"
860 How to use conditional format "ColorScale"
861 How to use conditional format "Arrows"
862 How to designate duplicates in different colors
863 How to enter only numbers (0 to 9) and Letters (A-Z, a-z) in a textbox
864 How to scroll up and down in a listbox
865 How to calculate end of month / end of year from a given date
866 How to scroll to the actual date
867 How to get register standard key
868 How to save worksheet without code
869 How to use AutoFilter in listobject with date
870 How to hide page break in all sheets of workbook
871 How to show countries and cities in a treeview control
872 How to get data from sheet to listview control
873 How to get data from sheet to listview control and evaluate selected data
874 How to use Progressbar to process data
875 How to reduce column width Column A in all sheets
876 How to delete all names with wrong ref (#REF)
877 How to hide headings in every sheet of actual workbook
878 How to clear screentips of all hyperlinks in actual workbook
879 How to show page break view for every sheet
880 How to use Inputbox to select a range
881 How to use function AutoFill to fill numbers with step=5
882 How to show dialog font with desired font as default
883 How to use method BorderAround to border an area
884 How to sort sheet by birthday of persons
885 How to find and color latest date in column A
886 How to select all cells in sheet with error in formula
887 How to check for valid date in textbox
888 How to insert copyright character in a textbox by press space bar
889 How to remove all checkboxes in sheet (OLEObjects)
890 How to remove all checkboxes in sheets (Shapes)
891 How to insert dropdown, fill it and link to cell
892 How to remove Reference to word library
893 How to show cell context menu without right click
894 How to fill a combobox in a userform with monthnames
895 How to use builtin dialog to protect worksheet
896 How to protect whole workbook
897 How to select next/previous sheet
898 How to name range and insert validation list to several sheets
899 How to sort data after input automatically
900 How to fill combobox in userform and show all entries by click
901 How to show all data in a filtered list
902 How to use API ShellExecute to write Mail or open internet
903 How to show/hide ribbon bar
904 How to open PDF file in browser
905 How to save actual sheet as PDF file
906 How to change view at sheet
907 How to remove rows in sheet if Column A is empty
908 How to get data from an access table
909 How to use Select case für identify letters from A to Z
910 How to search for text in Column and report address of cell
911 How to color a listview column with one click
912 How to combine chartobject with a listview control
913 How to Change plot order of a chartobject
914 How to format lines of a chartobject to thick lines
915 How to smooth all lines in a chartobject
916 How to add / remove markerstyle from a line chart
917 How to use special symbols as marker style in a line chart
918 How to get color for chartseries from cell C1 and D1
919 How to copy chartobject from one sheet to another sheet
920 How to insert chart title and link it to cell D1
921 How to show / hide datalabels in a chartobject
922 How to remove all comments out off a module
923 How to list all outlook mails in sheet
924 How to calculate days to year end
925 How to calculate days since year begin
926 How to put a range to an array, manipulate data and write it to sheet2
927 How to insert all picture from a folder in one sheet
928 How to protect sheet and allow select and edit only yellow cells (not locked)
929 How to color all cells in usedrange of sheet with text
930 How to sort data in sheet by color
931 How to color all merged cells in active sheet
932 How to create a cell address from two other cells
933 How to detect all error in formulas of a sheet and color them
934 How to detect all cells with leading apostroph
935 How to dispose Characters to columns
936 How to react to input in yellow cells
937 How to color all Textbox in userform and define font
938 How to remove all worksheet events from sheets
939 How to insert new sheet and name it with only one command
940 How to prevent selecting several cells at once
941 How to determine sheet name of named range
942 How to change codename of sheet
943 How to use ENUM
944 How to find unique smallest value in range
945 How to find unique greatest value in range
946 How to color all cells above average
947 How to move new worksheet at the end of workbook
948 How to move new worksheet at then begin of workbook
949 How to copy a range to every new worksheet
950 How to calculate after entering a sheet
951 How to turn calculation in all sheets on/off
952 How to prevent to insert a chart
953 How to set numerformat after inserting new worksheet
954 How to name a new worksheet automatically
955 How to insert "X" after double click with mouse in column A
956 How to start event Worksheet_BeforeDoubleClick with the help of a macro
957 How to open file with help of double click to yellow cell
958 How to use the double click to start a macro
959 How to import workbook event from a textfile
960 How to insert Worksheet_Change event in all worksheets
961 How to write a cell (a few techniques)
962 How to define window size (minimized, normal, maximized)
963 How to split window on a cell
964 How to arrange windows
965 How to insert empty column before a certain column
966 How to identify selection (cell or shape?)
967 How to clear all hyperlinks in sheet
968 How to show formula Autocomplete during input
969 How to get a list of available addins
970 How to get all "AllowEditRanges" in sheet
971 How to delete all "AllowEditRanges" in sheet
972 How to add a new "AllowEditRange" in sheet
973 How to define a scrollArea with usernames
974 How to insert header with lower font size in all sheets
975 How to change backcolor and font of all comments in workbook
976 How to find last price of a product
977 How to find first price of a product
978 How to get version of excel
979 How to process all files in a folder using loop
980 How to select only certain cells in a worksheet
981 How to check if an application has been started
982 How to calculate formulas in a worksheet (calculation is off)
983 How to use AutoFill function to fill formulas down
984 How to use function AutoFill with different increment
985 How to use function AutoFill with linear trend of numbers
986 How to use function AutoFill only with formatting
987 How to color all editable cells in protected sheet
988 How to color all differences in Column A based on comparison value in cell A1
989 How to compare cell A1 with all other cells in row 1 and color all differences
990 How to use an AutoFormat for a range
991 How to get all named ranges without printarea
992 How to check if printArea is available
993 How to define print title row for all worksheets
994 How to define print title Column for all worksheets
995 How to Freeze / reset windows a certain cell
996 How to color all error values in worksheet
997 How to prevent from selecting several ranges in a sheet
998 How to calculate a date into future
999 How to insert column to listobject
1000 How to insert row to listobject
1001 How to prevent saving a file
1002 How to prvent saving file with another filename
1003 How to find key with function VlookUp
1004 How to set focus to a combobox in a userform by leaving textbox
1005 How to find formatted value in a Column
1006 How to delete all workbook events
1007 How to delete special rows with help of autofilter
1008 How to sort empty rows to the beginning of list
1009 How to create random numbers in several ranges
1010 How to add conditional formatting in a range
1011 How to use different fonts and font size
1012 How to insert new worksheet and name it
1013 How to remove file from desktop
1014 How to copy file from desktop to another folder
1015 How to check existence of file and rename it
1016 How to remove folder
1017 How to create a new folder
1018 How to write usedrange in an array
1019 How to create unique list with use of DAO
1020 How to list all sound files
1021 How to use function autofill with step 0, 5, 10, etc..
1022 How to insert a PDF file as icon
1023 How to add chart and adjust to given cell
1024 How to check Autofilter and activate it
1025 How to fill an array and write it to first row
1026 How to fill an array and write it to column A
1027 How to find an color several max values
1028 How to add several charts and link them to data
1029 How to program a progressBar with percentage of rest runtime of macro
1030 How to export sheets without formulas, shapes and named ranges
1031 How to consolidate sales for every costcenter with DAO
1032 How to format several ranges
1033 How to get all selected sheets in a workbook
1034 How to remove all columns after column H
1035 How to add a border to several ranges
1036 How to count unique values in a listobject
1037 How to call builtIn dialog "Insert hyperlink"
1038 How to remove duplicates from every column
1039 How to fill listbox with several columns dynamically
1040 How to calculate a final date with workdays
1041 How to calculate average in Array (fifth row)
1042 How to calculate average in array (first column)
1043 How to consolidate sales per month
1044 How to fill an array, transpose it and insert into other sheet
1045 How to calculate sum for every row in an array
1046 How to calculate sum of all columns in an array
1047 How to determine min value of every column in array
1048 How to consolidate sales per month and costcenter
1049 How to use advancedFilter to get special data from a list
1050 How to export data to several sheets based on a criteria
1051 How to hide/show lines in a chartObject by clicking checkboxes
1052 How to send several reporting files to different customers
1053 How to define a scrollarea after opening workbook
1054 How to protect your data with doubleClick
1055 How to sum all sales of certain product groups
1056 How to read first 10 rows if a sheet using SQL
1057 How to transfer all data of sheet to another sheet (SQL+ADO)
1058 How to use autofilter with several entries in one column
1059 How to use autofilter with several criteria
1060 How to sort a listObject based on a column
1061 How to remove first column out of listobject
1062 How to copy data from listobject to another listobject
1063 How to add conditional border to cells
1064 How to extract TOP 10 sales from a sheet
1065 How to create unique list (DAO)
1066 How to get consolidated sum of sales (DAO & ADO)
1067 How to use advanced filter in a listobject
1068 How to get unique list out of a listobject
1069 How to export an certain range to PDF
1070 How to add slicer to a listobject
1071 How to check if a cell belongs to a listobject
1072 How to check existence of a listobject in a workbook
1073 How to show/hide title in listobject
1074 How to insert sum function to listobject
1075 How to define default table style in active workbook
1076 How to put current region of cell A1 to a listobject
1077 How to read listobject (Address, Name and first column)
1078 How to get different subtotals in a listObject
1079 How to put listobject column to an array
1080 How to add listobject and name it
1081 How to resize a listobject
1082 How to add autofilter to listobject
1083 How to filter current month in a listObject
1084 How to filter listobject with icons
1085 How to filter listobject with traffic lights
1086 How to filter listobject with font color
1087 How to filter listobject with cell color
1088 How to remove result row in listobject
1089 How to determine start row in listobject
1090 How to copy column of listobject and paste only values to other sheet
1091 How to copy whole listobject to other sheet
1092 How to get address of a listobject
1093 How to get name of a listobject
1094 How to get names of all columns in a listobject
1095 How to extract month from date
1096 How to extract montname from date
1097 How to remove all data from a listobject (keep title)
1098 How to unlist all listobjects in workbook
1099 How to delete all rows out of a listobject with price lower 50
1100 How to delete active row in listobject
1101 How to name a listobject
1102 How to unlist and add a listobject
1103 How to delete listobject
1104 How to use autofilter to filter all not empty rows in listobject
1105 How to filter all empty rows in a listobject
1106 How to use advanced filter in listobject
1107 How to count filtered rows in listobject
1108 How to copy filtered rows to sheet (without title)
1109 How to show all data in a listobject
1110 How to copy filtered rows to sheet (with titles)
1111 How to get size of a listobject (rows and columns)
1112 How to fill column A of listobject with new data
1113 How to color special rows in listobject
1114 How to insert comments into a listobject
1115 How to search in a listobject
1116 How to search and replace text in a text file (FSO)
1117 How to use the filedialog to call userfriendly dialogs
1118 How to remove duplicates based in two columns
1119 How to write first column of listobject into an array
1120 How to print whole workbook
1121 How to display/hide comments in a workbook
1122 How to delete all comments in active sheet
1123 How to delete all hidden worksheets
1124 How to insert picture to comments background
1125 How to remove empty rows in selection
1126 How to remove empty columns in selection
1127 How to check if a cell has a hyperlink
1128 How to extract first word out of a cell
1129 How to store multiselect form listbox in array
1130 How to check cells for correct lenght (use autofilter)
1131 How to check cells for correct lenght (use array)
1132 How to fill sheet names to a combobox
1133 How to show/hide a named range
1134 How to add name and hide it in name manager
1135 How to add a named range
1136 How to get data from a closed excel file (with password)
1137 How to use filepicker to show dialog open file
1138 How to get data from a closed file without opening
1139 How to read data from a protected workbook (read only)
1140 How to use a matrix formula to count numbers in Column B smaller than in Column A
1141 How to import data from a closed file without opening (DAO)
1142 How to color and protect all formula in active sheet
1143 How to export active workbook as pdf and it to the Desktop
1144 How to export all tables as PDF and save them to the Desktop
1145 How to unmerge all cells of active sheet
1146 How to hide all sheets except of the active sheet
1147 How to use dialog to insert hyperlink
1148 How to find a number in column A
1149 How to export active sheet to new workbook and remove all formulas and shapes
1150 How to write textfile with username and computername (append new data)
1151 How to save last access before closing file
1152 How to react after an entry in column B
1153 How to export all data in the future to a sheet (ADO & SQL)
1154 How to export all data with given criteria to another sheet (ADO & SQL)
1155 How to hide/show columns ( 2 different ways)
1156 How to hide/show different columns
1157 How to hide/show several rows
1158 How to hide / show a range
1159 How to fill as textfield in a worksheet
1160 How to add label to chartObject
1161 How to fill missing numbers in a column
1162 How to scale axis of chartobject from cells
1163 How to insert hyperlink with link to last sheet in workbook
1164 How to close workbook and shut down PC
1165 How to color all filled cells in a range
1166 How to enlarge cell dropdown
1167 How to import contact data from outlook
1168 How to read, change and write an array
1169 How to color series of a chartobject depend on value
1170 How to add chartobject, add new seriescollection and delete seriescollection
1171 How to use conditional formatting to color duplicates
1172 How to use conditional formatting to color unique numbers
1173 How to export all sheets with numeric name to a new workbook
1174 How to write formula in an array and later back to column in sheet
1175 How to calculate average in an array
1176 How to search number in an array
1177 How to search in an array with help of function
1178 How to use AutoFilter with several columns
1179 How to fill empty cells in a column
1180 How to add / remove a border in a range
1181 How to resize listobject
1182 How to color a commandbutton in a sheet
1183 How to loop through all cells in a range
1184 How to detect differences in two columns
1185 How to freeze all formulas in selected cells
1186 How to list all files in folder and add hyperlinks to them
1187 How to remove blanks out of cells (Soft space, too)
1188 How to find first colored cell in first row
1189 How to get monthname from custom list
1190 How to insert random numbers with an array formula
1191 How to remove all blanks in selected cells
1192 How to format all comments in workbook
1193 How to count all words in selected cells
1194 How to insert and format shape
1195 How to set column width
1196 How to set row height
1197 How to insert column and row
1198 How to find text and insert new row before text
1199 How to find text in column and insert empty row after it
1200 How to delete row or column
1201 How to copy only values from one sheet to another
1202 How to fill array, transpose data and paste to sheet
1203 How to use builtin dialog print with arguments (from - to - copies)
1204 How to get color from built in color palette
1205 How to use builtin save as dialog with arguments (filename & date stamp)
1206 How to write selected slicers to cell
1207 How to read all slicers in workbook and remove selected items
1208 How to transfer special data to another sheet
1209 How to remove duplicates with help of dictionary object
1210 How to count unique numbers in a range
1211 How to color all cells with line breaks
1212 How to insert hyperlink to different worksheets
1213 How to read all csv files in a folder and change columns position
1214 How to search data with several criteria
1215 How to track all changes in a worksheet
1216 How to get unique values to a combobox
1217 How to add new workbook with 7 days (weekdayname)
1218 How to add new workbook with 12 month (monthname)
1219 How to browse through a workbook
1220 How to count visible rows in a sheet
1221 How to create cell dropdown and fill it with an array
1222 How to fill a validation list with an array
1223 How to transfer data with two rows of information
1224 How to create validation list and dropd down it
1225 How to define column width for all sheets in workbook
1226 How to hide/show headings for all sheets in active workbook
1227 How to clean hyperlink screen tips in all sheets
1228 How to fill data downwards with step 5
1229 How to border a range
1230 How to print a module
1231 How to get unique numbers from a range and write them to sheet
1232 How to use autofilter with wildcards
1233 How to monitor a range in a sheet
1234 How to get sheetname and reference of named range
1235 How to get unique values from a column and paste it to other column
1236 How to search for title and sum data
1237 How to track all changes in column A and write date/time in column B
1238 How to repeat an entry on several tables
1239 How to color all cells greater then a given cell
1240 How to color all cells equal a given number
1241 How to name a range and select it
1242 How to protect / unprotect all sheets of workbook
1243 How to use double click event to insert a hook
1244 How to show userform and unload after 2 seconds
1245 How to protect/unprotect all sheets in workbook (charts too)
1246 How to insert footer with last save time in all sheets
1247 How to activate all item in pivot table rowfield
1248 How to activate only a few items in pivot table rowfield
1249 How to extract date from a text
1250 How to insert a border to usedrange of sheet
1251 How to use autofilter Top 10
1252 How to filter highest sales in column
1253 How to use several criteria with autofilter
1254 How to use autofilter with sales from … to
1255 How to hide filters arraw and filter all cities beginning "M*"
1256 How to get all installed fonts
1257 How to read all items of pivot columnfield
1258 How to get first item in columnfield of pivottable
1259 How to get all item of pivot tables rowfield
1260 How to get all items of pivot tables pagefield
1261 How to uncolor empty cells
1262 How to set date stamp after printing for all sheets
1263 How to prevent leaving a workbook
1264 How to set cursor to cell A1 after activating sheet
1265 How to delete all chart objects in worksheet
1266 How to show/hide chart title
1267 How to insert spark lines
1268 How to reduce a range
1269 How to resize a range
1270 How to save copy of actual workbook
1271 How to remove rows based on several criteria
1272 How to find row based on a key
1273 How to convert input to upper case
1274 How to react on enter data in several sheets
1275 How to check date for weekday
1276 How to check whether a date occurs in several columns
1277 How to print sheet for every day of month
1278 How to check existence of a folder
1279 How to remove empty rows
1280 How to remove a character from a cell
1281 How to monitor column A and adjust entered value
1282 How to check value in cell (A1) and change the background color of a shape
1283 How to detect oldest file in folder
1284 How to prevent too many inputs in a given range
1285 How to write report with orders and contacts
1286 How to record all deletions in an area in a comment
1287 How to Check whether all yellow cells have been filled in
1288 How to print all worksheets in reverse order
1289 How to prevent selecting any cell in column A
1290 How to fill listbox with data from a column
1291 How to export all numeric named sheets to new workbook
1292 How to export worksheets to new workbook with an array
1293 How to select all worksheets in active workbook
1294 How to select two of three worksheets
1295 How to get computername using Wscript
1296 How to get username using wscript
1297 How to reset all filter criteria in whole workbook
1298 How to search for formatted text "Total"
1299 How to search for number in range (begin at the end of range)
1300 How to search for number in range (Start at beginning of range)
1301 How to color all cells with formula
1302 How to set width of several columns
1303 How to filter numbers to another sheet without headers
1304 How to use filter in an array
1305 How to use dialog to choose folder
1306 How to set several criteria to autofilter using an array
1307 How to separate text with help of function split
1308 How to get protection status of active workbook
1309 How to open a workbook "read only"
1310 How to name a range and hide/show name in names manager
1311 How to color all filtered cells
1312 How to convert all seleced cells to real date format
1313 How to get data from several worksheets to one sheet
1314 How to hide / show rows and columns
1315 How to replace characters in whole column
1316 How to use redim in an array
1317 How to start an array with index 1
1318 How to open protected workbook
1319 How to start print preview for all selected sheets
1320 How to select / deselect sheets
1321 How to find last row in a special range
1322 How to check a valid E-Mail address
1323 How to get value from the worksheet before
1324 How to read colorindex from conditional formatted cells
1325 How to insert column after every fifth column
1326 How to "mirror" two cells
1327 How to transfer data from one sheet to another sheet
1328 How to color cells with validation rule
1329 How to get all cells with conditional formatting rules
1330 How to get all cells containing comments
1331 How to get all cells containing text and color them
1332 How to get all cells containing numbers (no formulas)
1333 How to color all cells containing formulas
1334 How to sum values by number
1335 How to remove rows with special numbers
1336 How to sum all values of existing groups
1337 How to find first empty column in worksheet
1338 How to find first empty row in range
1339 How to select rows with inputbox
1340 How to filter dates automatically
1341 How to color worksheet tab depending of value
1342 How to hide conditional formatted rows
1343 How to hide columns
1344 How to select next sheet
1345 How to list drive info
1346 How to write and read a textfile
1347 How to read e-Mails
1348 How to transfer several rows to another worksheet
1349 How to transfer data to sheet, convert to pdf and send by E-Mail
1350 How to hide several rows and columns
1351 How to color best three products each month
1352 How to fill several dependent comboboxes with data using SQL & ADO
1353 How to create a conditional sum with SQL & ADO
1354 How to fill empty cells with value above
1355 How to filter rows in listObject
1356 How to delete rows in a listObject
1357 How to clear blanks out of cells
1358 How to sort data by userdefined method
1359 How to hide rows with non yellow cells
1360 How to color start and end position of a number in rows
1361 How to detect missing and double numbers
1362 How to split text and show first part
1363 How to split text and show second part
1364 How to write windows caption
1365 How to find a formatted number in column
1366 How to show splash screen for two seconds
1367 How to start windows notepad
1368 How to determine start and end position of blanks
1369 How to remove all blanks in a range
1370 How to create table of content for worksheets
1371 How to list all formulas and links of a workbook (Tool)
1372 How to search for a text in whole workbook (Tool)
1373 How to insert validation list into several worksheets
1374 How to show and hide a range
1375 How to format columns in text-format
1376 How to search for text (case sensitive)
1377 How to transfer data frim one column to several columns
1378 How to use saveas dialogue with path and filename
1379 How to fill range with random numbers
1380 How to color rows in alternation with two colors
1381 How to track all changes in a worksheet
1382 How to number pages in a worksheet
1383 How to change selection and scroll windows
1384 How to send e-mail with HTML tags
1385 How to get text of a textbox as E-Mail body
1386 How to get users desktop
1387 How to list all 56 colors in a worksheet
1388 How to collect rows and hide them at the end of a macro
1389 How to identify data of a pivot table
1390 How to transfer special rows to another worksheet
1391 How to fill a report with data using Arrays
1392 How to read, change and write conditional formatting
1393 How to export and import a vba module
1394 How to calc every cell in range without a loop
1395 How to identify windows version (32 odr 64 bit)
1396 How to add/read/delete an userdefined property to a worksheet
1397 How to manage userdefind function with optional parameter
1398 How to read first column of an array
1399 How to read first row from an array
1400 How to fill down a formula
1401 How to format cells in a special modality
1402 How to find smallest values in a range - V.1
1403 How to find smallest values in a range - V.2
1404 How to replace several characters in a range
1405 How to create export files automatically
1406 How to delete rows depend on given date
1407 How to count all saturdays in a sheet
1408 How to format all negativ values in a sheet
1409 How to change zoom of all worksheets
1410 How to fix/unfix windows of all sheets
1411 How to count selected sheets
1412 How to count visible rows in a listObject
1413 How to use SaveAs dialogue
1414 How to process all files in a directory
1415 How to find first free cell in column
1416 How to find last used cell in column
1417 How to clear all conditional formatting
1418 How to format different areas of a chart
1419 How to insert chart an link to data
1420 How to format marker in a chartObject
1421 How to insert a label to a chartObject
1422 How to use dialogue FileOpen to select several files
1423 How to use dialogue FileOpen to select one file
1424 How to export all vba codes to text file
1425 How to import a text file in a worksheet
1426 How to format all comments in sheet
1427 How to remove all spaces in a worksheet
1428 How to invert a selection
1429 How to change minus to plus and reset it
1430 How to add gridlines to range
1431 How to insert textbox and format it
1432 How to add an array and fill it with random numbers and characters
1433 How to search for text and reference to range
1434 How to show all worksheets in workbook
1435 How to fill array with names of dropdowns
1436 How to read CSV file to worksheet
1437 How to use drag & drop for two listboxes
1438 How to show / hide textboxes in a userform
1439 How to send active workbook via mail
1440 How to fill empty cells with zeros
1441 How to convert all formulas in workbook to values
1442 How to convert all formulas in active sheet to values
1443 How to read first and last cell of a named range
1444 How to enter a date to outlook calendar
1445 How to format a column as currency
1446 How to check, if active sheet is protected
1447 How to look for smallest values in given range
1448 How to find greatest value in cell with line breaks
1449 How to split cell with several line breaks
1450 How to fill an array with titles and transpose
1451 How to fill an array with value of cells and use it as title of sheet
1452 How to remove several characters out of a cell
1453 How to split an address and put it together again
1454 How to print several areas of a sheet at once
1455 How to print several areas of a sheet using Union
1456 How to fill a range cell by cell
1457 How to remove empty folders
1458 How to count capitals letters in a cell
1459 How to find a given name in a column
1460 How to protect sheet allowing filtering and outlining
1461 How to add new folder in outlook email inbox
1462 How to transfer excel cell value to word document
1463 How to scroll screen
1464 How to change buttons color based on cell value
1465 How to transfer excel range to word document
1466 How to fill an array from column A and put it to column H
1467 How to use API function to show folder picker
1468 How to use Shell object to show folder picker
1469 How to insert a space at a certain position
1470 How to react to a double click inserting a tick
1471 How to close workbook without saving
1472 How to determine size of all fles in folder
1473 How to determine pathname of an opened text file
1474 How to determine depth of a folder
1475 How to determine drive name
1476 How to determine info about a file
1477 How to use function InStr
1478 How to use operator like to find text
1479 How to determine row height
1480 How to determine column width
1481 How to set optimum column width
1482 How to create a dynamic range
1483 How to transpose rows to columns
1484 How to transpose one column to range
1485 How to assign one macro to two shapes
1486 How to insert shape and fit to cell
1487 How to prevent to enter an area
1488 How to prevent enter a special row
1489 How to prevent enter a special column
1490 How to use function StrConv to convert text
1491 How to convert every first letter of a word to uppercase
1492 How to convert uppercase for each selected cell
1493 How to delete empty Columns in sheet
1494 How to compare columns and detect double values
1495 How to move a shape from one position to another position
1496 How to export sheet to text file
1497 How to determine unique values and export to sheet
1498 How to detect differences in two ranges
1499 How to compare ranges and color differences
1500 How to move a shape to a specific position
1501 How to create random numbrs without duplicates
1502 How to fill dropdowns with month name and names of weekdays
1503 How to traverse several ranges and color cells with zeros
1504 How to color empty cells in several ranges
1505 How to fill empty cells in a range with zeros
1506 How to fit data on one print page
1507 How to protect all worksheets in workbook
1508 How to select several sheets at once
1509 How to fill Textbox from cell A1 (MultiLine)
1510 How to export sheet as PDF and send it by outlook mail
1511 How to group a list by weekend
1512 How to scroll entry from combobox to first position
1513 How to group columns by weekend
1514 How to write and read text file (skip characters)
1515 How to skip rows in a text file using FSO
1516 How to write text file with several rows, empty rows too
1517 How to create text file with several empty rows
1518 How to open text file and append row
1519 How to determine parent folder of a file
1520 How to determine name of file
1521 How to determine path of special folders (FSO)
1522 How to create text file and write one line (FSO)
1523 How to extract number from cell
1524 How to format several columns
1525 How to select used cells in columns
1526 How to color two columns at once
1527 How to use dialogue to insert picture
1528 How to remove rows containing text in first column
1529 How to delete columns containing date in first row
1530 How to find rows containing word "Sum" in first column
1531 How to find and delete a special row
1532 How to format line in chartobject
1533 How to link visible cells in a range
1534 How to transfer text from a given word to then end of text
1535 How to select a range with inputBox
1536 How to link data to a chart
1537 How to scroll activecell above
1538 How to address a worksheet
1539 How to format a header of a worksheet
1540 How to create pivot table
1541 How to send mail with clickable hyperlink
1542 How to send mail with link to a file
1543 How to color a range
1544 How to count rows in text file (FSO)
1545 How to compare two sheets and color differences
1546 How to fill and clear several ranges in worksheet
1547 How to compare ranges and color matching values
1548 How to check existence of a worksheet
1549 How to hide / show a range
1550 How to show / hide several rows
1551 How to calculate HEX-value of a colored cell
1552 How to find all cells containing validation rules
1553 How to find all cells with conditional formatting
1554 How to find all cells with comments
1555 How to find all cells with text
1556 How to find all cells with numbers (without formulas)
1557 How to find all formulas in a range using loop
1558 How to find all formulas in a range using methode SpecialCells
1559 How to find all empty cells in a range
1560 How to find first empty cell in column A
1561 How to find first empty cell in column A (from top)
1562 How to find formulas in sheet
1563 How to sum values of several different numbers
1564 How to delete several rows in a sheet
1565 How to split text based an a given character
1566 How to sum every number in a sheet
1567 How to use autofilter and export as pdf
1568 How to color Top-3 values für each month
1569 Copy and transpose data to another sheet
1570 How to insert columns every fifth column
1571 How to change signs (+ to - and - to +)
1572 How to invert a selection
1573 How to trim blanks out of cells
1574 How to format all comments of a sheet
1575 How to import text file to sheet
1576 How to export all modules as text files
1577 How to use dialogue Open to select a file
1578 How to use dialogue Open to select several files
1579 How to insert label into chart object
1580 How to format data marker in chart object
1581 How to format data marker of a chart object with color from cells
1582 How to insert chart object and link to data
1583 How to identify different areas of a chart object
1584 How to delete all conditional formatting out of a workbook
1585 How to loop through all files in a directory
1586 How to use SaveAs dialogue
1587 How to count visible rows in listobject
1588 How to count all grouped worksheets
1589 How to unfreeze all windows in workbook
1590 How to zoom all worksheets to the same zoom factor
1591 How to format negative numbers by red color
1592 How to count all saturdays in a list
1593 How to delete rows before a given date using loop
1594 How to delete rows before a given date using Autoflter
1595 How to read text file row by row
1596 How to replace several characters at once
1597 How to find smallest values in a range
1598 How to find special values in a range using loop
1599 How to format cells with black cross
1600 How to fill in formulas downwards
1601 How to fill an array with a range and get first row
1602 How to get first five fields of an array
1603 How to add, read and delete a custom worksheet property
1604 How to get windows version (32 or 64 bit)
1605 How to calculate several cells without a loop
1606 How to export and import a module to another workbook
1607 How to read, change and write conditional formatting
1608 How to write data in a matrix of a sheet
1609 How to transfer special rows to sheet using an array
1610 How to identify and color datarange of a pivot table
1611 How to hide rows (value in Column A <=50)
1612 How to get index of all 56 colors
1613 How to get first free column in range
1614 How to get first free row in range
1615 How to select row(s) with help of inputbox
1616 How to filter data after input in cell D1
1617 How to color worksheet tabs after input in cell A1
1618 How to hide colored cells (conditional formatting)
1619 How to hide numeric columns
1620 How to skip next sheet
1621 How to get drive info
1622 How to create and read text file with FSO
1623 How to transfer rows to worksheet with to copy them
1624 How to filter, export and mail data
1625 How to hide not used rows and columns
1626 How to format best and worst sales of each month
1627 How to use autofilter in listobject
1628 How to delete rows in a listObject
1629 How to trim blanks out of cells
1630 How to sort a list in custom order
1631 How to hide all non yellow cells
1632 How to color every changing number in column A
1633 How to find missing and duplicate numbers
1634 How to change and reset windows title
1635 How to search for number and format
1636 How to show a splashscreen
1637 How to start notepad
1638 How to create table of content of all sheets in a workbook
1639 How to write all formulas of a workbook (Tool)
1640 How to search for text in several workbooks (Tool)
1641 How to insert validation list to special sheets
1642 How to hide range if cell value changes
1643 How to encrypt macro
1644 Format columns in text format
1645 How to search for text with distinction of upper and lower case
1646 How to split a column into many columns
1647 How to use Save as dialogue with given name and path
1648 How to fill range with random numbers between 1 and 100
1649 How to color rows alternately
1650 How to identify sheets based on tab color
1651 How to set a continuous page numbering
1652 How to set cursor and scroll
1653 How to send e-mail with HTML tags
1654 How to send e-mail with text from a textbox including HTML-tags
1655 How to determine users desktop
1656 How to move entries in a listbox (Tool)
1557 How to insert apostroph to the beginning of each cell
1658 How to prevent user to add new sheets
1659 How to search for text in a listbox
1660 How to sort rows in a listbox (Tool)
1661 How to insert shape in a cell
1662 How to copy dynamic range to another sheet
1663 How to transfer dynamic range to another sheet without copying
1664 How to transfer data, remove duplicates and sort
1665 How to transfer data, remove duplicates, sort and transpose
1666 How to sort text like numbers
1667 How to select first row of a range
1668 How to select last cell in range
1669 How to select first cell in range
1670 How to select second column of a range
1671 How to transfer several entries from on listbox to another listbox
1672 How to format range with border, font and color
1673 How to clear all formats in range
1674 How to search for text in other sheet
1675 How to name usedrange of a sheet
1676 How to set name to a dynamic range
1677 How to group all cells with text
1678 How to group rows based on cell value
1679 How to group rows with same values
1680 How to hide special columns
1681 How to identify button in sheet
1682 How to show / hide button based on cell value
1683 How to delete all shapes in sheet
1684 How to delete special shapes in a sheet
1685 How to transpose a range
1686 How to tranpose ramnge with help of an array
1687 How to transpose range and transfer to other worksheet using array
1688 How to Transpose range and transfer to sheet using method PasteSpecia
1689 How to fill array with random numbers and transfer to sheet
1690 How to fill array with random numbers and tranpose to sheet
1691 How to fill array with letters (A to Z) and transpose it
1692 How to fill array with names of a list
1693 How to create export pdf for each region
1694 How to find special values in range
1695 How to loop through several ranges using an array
1696 How to loop through several ranges using loop
1697 How to fill and manipulte array and paste to sheet
1698 How to fill array with several ranges of sheet
1699 How to copy current region of cell and paste to other sheet
1700 How to copy several ranges and paste to other sheet without empty columns
1701 How to show / hide shape after doubleclick to cell
1702 How to transfer dates and descriptions to outlook calendar
1703 How to add sparklines to range
1704 How to insert sparkline with a capped max value
1705 How to compare two sheets
1706 How to insert pivot table
1707 How to prevent to enter special columns
1708 How to transfer special rows to other sheet
1709 How to delete special rows in a sheet
1710 How to determine color of tabs
1711 How to determine range without title row
1712 How to determine current region of cell without title row
1713 How to transfer all filtered rows to another sheet
1714 How to get data rage of sheet without titles and rows with results
1715 How to check input in given range
1716 How to check input in named range
1717 How to check input in several ranges
1718 How to protect formulas without sheet protection
1719 How to convert data with help of an array
1720 How to documentate all changes in Column in comment
1721 How to fill cell comment and drawing object with maximum of characters
1722 How to insert and name sheet for each day of a month
1723 How to find a date in a column
1724 How to use AutoFilter with date
1725 How to use InputBox with text
1726 How to use InputBox with date
1727 How to detect and color wrong data
1728 How to get data of sheet based on a unique key
1729 How to search for a string and color font
1730 How to use event worksheet_SelectionChange to color cells
1731 How to start count down after input in cell A1
1732 How to react on double click and color cells
1733 How to delete empty rows in listobject
1734 How to start website and click link
1735 How to get info about website in immediate window
1736 How to log in to a website
1737 How to create csv file from a sheet
1738 How to fill combobox with array
1739 How to fill combobox with cells (array)
1740 How to fill combobox with two columns array
1741 How to search for number in range
1742 How to search for number in whole workbook
1743 How to search for number in other workbook
1744 How to show all data in pivot tables filter
1745 How to hide all empty rows in pivot table
1746 How to align input automatically
1747 How to get position of button
1748 How to get picture from sheet to userform
1749 How to show several pictures form sheet to image control
1750 How to get column number of named range
1751 How to number a list
1752 How to color every character in string with different color
1753 How to hide columns after choosing entry in cell A2
1754 How to fill and search an array
1755 How to hide sheet1 and show after 2 seconds again
1756 How to document all changes in a sheet
1757 How to format and send e-mail
1758 How to send e-mail with colored font
1759 How to determine size of an array
1760 How to get value above after doubleclick to empty cell
1761 How to create a separate access system
1762 How to set subtotals in pivot table on and off
1763 How to color all named ranges in active workbook
1764 How to insert conditional formatting "rule value greater than"
1765 How to insert conditional formatting "rule value smaller than"
1766 How to insert conditional formatting "rule value between X and Y"
1767 How to identify typing errors in sheet
1768 How to insert chart object and link to data
1769 How to align chart object to a cell
1770 How to insert and test different chart types
1771 How to change background color of a chart object
1772 How to copy data and tranpose to other sheet
1773 How to save workbook as HTML file
1774 How to use toggle button to change color of cell alternately
1775 How to export active sheet to PDF
1776 How to insert empty row every second row
1777 How to color every second row in sheet
1778 How to sort data by multiple criteria
1779 How to get all comments of a sheet and write them to other sheet
1780 How to get comments of sheet and export to word document
1781 How to fill array from range and debug field by field
1782 How to find last used row and column in sheet
1783 How to insert blanks before a number
1784 How to insert blanks after a number
1785 How to fill cells with zeros after number
1786 How to fill cells with leading zeros
1787 How to change the orientation of text in a cell
1788 How to save all sheets as separate PDF-files
1789 How to export special sheets as pdf
1790 How to get all linked excel files of a workbook
1791 How to update only one linked excel file
1792 How to use autofilter and sort together
1793 How to transfer rows to other sheets using ADO & SQL
1794 How to get sheets codename of closed workbook
1795 How to get sheets codename of closed workbook using function
1796 How to get all data from one date to another date
1797 How to get data with help of SQL and write reslts in immerdiate window
1798 How to extract special data using ADO / SQL
1799 How to transfer all rows where sale is above average
1800 How to lock /unlock sheets textbox
1801 How to clear several cells in sheet at once
1802 How to clear all cells with numbers
1803 How to copy non-contiguous cells
1804 How to lock cells after input
1805 How to select range with help of inputbox
1806 How to select folder with Object FileDialog
1807 How to identify duplicate numbers
1808 How to remove line breaks in cells of whole sheet
1809 How to select whole row and column of active cell
1810 How to color all values greater than a given number
1811 How to color all values greater than a given number
1812 How to compare cells in range A2:A10 and color differences to cell A1
1813 How to compare cell with cell above
1814 How to protect all cells with formula
1815 How to get data from closed workbook without opening
1816 How to get data sorted from closed workbook using SQL & ADO
1817 How to sum sales of every country
1818 How to calculate average sale of each country
1819 How to calculate max sale of each country
1820 How to calculate TOP 10 sales of customers
1821 How to check if a filename is correct
1822 How to count all numbers for each date (SQL)
1823 How to add org chart
1824 How to collect data from several sheets (SQL)
1825 How to save copy of workbook without formulas
1826 How to copy range without titles
1827 How to color all cells value smaller than given number
1828 How to fill cells with leading zeros
1829 How to insert and delete empty rows
1830 How to insert hyperlink to other workbook
1831 How to insert QR code in sheet
1832 How to allow input only one time
1833 How to navigate to other cell after selecting cell
1834 How to fill and search an array
1835 How to fill array with random numbers and characters
1836 How to find a key in array
1837 How to show crosshair after double click to cell
1838 How to find row number in array using "find"
1839 How to find row number in array using "match"
1840 How to search several numbers in a range
1841 How to copy filtered data without title row
1842 How to put formula of active cell in comment
1843 How to save all changes in column A in comments
1844 How to transfer filtered data of listObject to other sheet
1845 How to protect data in a sheet without Excels sheet protection
1846 How to update data and color new and changed data
1847 How to create an alternative control of form
1848 How to check cells if value is odd or even
1849 How to copy range and append to other sheet
1850 How to sum colored cells
1851 How to export hidden worksheet to pdf file
1852 How to save range as PDF and mail it
1853 How to get active cell scrolled to top, left corner
1854 How to prevent entering to forbidden area
1855 How to enlarge selected cell
1856 How to sum several numbers to a group and color them
1857 How to find highest value in a cell with several rows
1858 How to remove double numbers using dictionary object
1859 How to insert an apostroph before each cell in column A
1860 How to sort a list to userdefind method
1861 How to delete rows in a listobject
1862 How to add, read and delete a custom property for a sheet
1863 How to check if a workbook is already open
1864 How to write formulas to cells
1865 How to delete next row (seen from active cell)
1866 How to prevent input of double numbers
1867 How to create user friendly textbox
1868 How to insert quarter pie to sheet
1869 How to insert control to ribbon
1870 How to split text to columns
1871 How to get random numbers to range
1872 How to search actual date in column A and insert new row before
1873 How to protect title rows in several sheets
1874 How to use AutoFilter with date
1875 How to determine oldest file in folder
1876 How to fill and search an array
1877 How to extract special data and sum amounts
1878 How to copy Sheets to other workbook
1879 How to move special sheets to other workbook
1880 How to insert borders after doublClick in range
1881 How to save text from textbox to cell
1882 How to use dialog "File open"
1883 How to find actual date in column
1884 How to create folders based on a list
1885 How to create animation effect during clearing a cell
1886 How to keep only the actual data
1887 How to fill an array and search array
1888 How to create your own access-system
1889 How to find all named ranges in worksheet
1890 How to filter data and transfer data to another sheet without title row
1891 How to use function Match to search in an array
1892 How to use method Find to search for number in range
1893 How to use SQL to transfer data from one sheet to another sheet
1894 How to use doubleClick in cell to select whole row and column
1895 How to fill range with random numbers and characters
1896 How to prevent input of double numbers
1897 How to use a SMS function for a textbox
1898 How to send mail with attachments
1899 How to insert quarter shape into sheet
1900 How to create your own access system für an excel file
1901 How to filter a listObject and put data to other sheet
1902 How to read data from a closed workbook without opening
1903 How to add/delete a control to add-ins menue
1904 How to use evaluate to sum data with criterias
1905 How to print name badge from excel in powerpoint
1906 How to fill collection without duplicates, sort and output to sheet
1907 How to fill an ArrayList and sort it
1908 How to compare two rows (quick coding)
1909 How to put text into a shape-object
1910 How to program a flexible pause (32/64 bit)
1911 How to quote text, put text into apostrophs
1912 How to remove duplicates and sort
1913 How to check if a folder/file exists
1914 How to check existence of a control
1915 How to use a sortedlist - determine first/last entry
1916 How to use SortedList - fill list and remove several rows
1917 How to use SortedList - fill two lists and create one list
1918 How to create unique list with SortedList
1919 How to fill Queue and check any items
1920 How to fill an ArrayList and check any items
1921 How to fill a stack and check any items
1922 How to fill stack and count items
1923 How to fill an arraylist and count items
1924 How to fill queue and read all fields
1925 How to remove empty rows from selection
1926 How to repeat characters any times
1927 How to Put text to clipboard and get text from clipboard
1928 How to create random numbers from 1 to 5
1929 How to create random numbers
1930 How to Fill queue with unique items and count items per unique item
1931 How to add entries to Queue and write to sheet
1932 How to fill queue, count entries and check existance of entry
1933 How to add controls during macros runtime
1934 How to transfer a range to an array (Value versus Value2)
1935 How to put dynamic range to array
1936 How to clear whole worksheet
1937 How to get unique numbers from a column
1938 How to add hours per person and date
1939 How to add hours per Month and person
1940 How to use left join with SQL/ADO
1941 How to use inner join with SQL/ADO - Compare quantity of two month
1942 How to use right join with SQL/ADO - Detect missing numbers
1943 How to create a dynamic unique list
1944 How to get table contents with SQL (table name from cell)
1945 How to merge tables with SQL
1946 How to create unique list from 2 tables
1947 How to merge several tables with SQL
1948 How to get data from a file that is in a specific date range
1949 How to summarize data with array/SQL
1950 How to fill a combobox uniquely and link it to a list field
1951 How to find and transfer records in array
1952 How to search array and find smallest value
1953 How to search array and find largest value
1954 How to search array and find last entry with match
1955 How to create unique list and link it to dropdown
1956 How to loop through a listobject (row by row, column by column)
1957 How to clear special cells in a worksheet
1958 How to use ADO/SQL to fill a Combobox and a listbox
1959 How to check text field for correct date entry
1960 How to read selected row from a dropdown
1961 How to create a pivot table
1962 How to create dynamic Checkboxes and images
1963 How to summarize data with dictionary or SQL
1964 How to extract data from a worksheet (Array; SQL)
1965 How to add row to listObject
1966 How to monitor a listobject column
1967 How to respond to a double-click in a ListObject
1968 How to change date after input of amount
1969 How to fill structure with help of Type and arrays
1970 How to copy row of a listObject to another listobject
1971 How to remove certain columns from a table
1972 How to unlock" several areas, protect the rest
1973 How to mark duplicate data in pairs
1974 How to write sum formula if not already present
1975 How to calculate average from a variable range
1976 How to fill number with zeros if too short
1977 How to merge and export accounts
1978 How to Summarize and export specific accounts with help of AutoFilter
1979 How to color weekends and Christmas
1980 How to fill collection and dump specific columns into target table
1981 How to use Array and collection in interaction
1982 How to fill collection and dump into a column
1983 How to fill an array / Collection with 5 million fields
1984 How to open a web page with FollowHyperlink
1985 How to open a file with FollowHyperlink
1986 How to open a folder in windows Explorer
1987 How to collect and output specific entries in a dictionary
1988 How to extract specific parts from array (API)
1989 How to extract specific parts from array
1990 How to extract specific rows from array
1991 How to extract specific fields from an array
1992 How to transfer selected tables to new workbook
1993 How to set layout of pivot table (cells with zero)
1994 How to define the layout of a pivot table (grid, column and row frames)
1995 How to show subtotals and align on top
1996 How to set pivot layout, set row and column titles
1997 How to repeat pivot field names for row fields
1998 How to clear filter in page field of a pivot table
1999 How to show/hide subtotals/totals in pivot
2000 How to show subtotals/total in pivot
2001 How to determine all users
2002 How to remove duplicate data
2003 How to remove duplicate data (with method RemoveDuplicates)
2004 How to remove duplicate data (Array)
2005 How to remove duplicate data (Array+Dictionary)
2006 How to remove specific rows with data filter in all tables
2007 How to remove filtered rows with character "X"
2008 How to prevent wrong input in a column
2009 How to prevent double entries in a column
2010 How to protect a range and hide formulas
2011 How to create a backup copy
2012 How to Convert data
2013 How to Include or remove "Scripting Runtime" library via macro
2014 How to Create a text file via the file system object and make an entry
2015 How to use the open dialog
2016 How to interrupt processing a macro
2017 How to make a check if an object is known
2018 How to measure the runtime of a macro
2019 How to check the beginning of a string
2020 How to switch between cell references
2021 How to use an Array in userdefined function (office 365 and higher)
2022 How to clear immediate window
2023 How to define several columns by text
2024 How to round on basis of 5 cents
2025 How to detect missing numbers
2026 How to loop through a range row by row
2027 How to loop through a range column by column
2028 How to create a range of several rows
2029 How to fill and transpose an array
2030 How to detect missing numbers with alphanumeric content
2031 How to create a text file
2032 How to create a text file and write a line
2033 How to create a button
2034 How to read the cell number formats
2035 How to perform a unique search
2036 How to remove line breaks
2037 How to find the last used row and column (method find)
2038 How to find the last used row and column (property end)
2039 How to work with a user defined data type
2040 How to get the computer name without API
2041 How to get the computer name with API
2042 How to freeze a window at a specific row and column
2043 How to loop through a filtered list cell by cell
2044 How to show and hide an autofilter
2045 How to remove and set an autofilter in a listobject
2046 How to set a border to a range
2047 How to border around a named range
2048 How to send an email via API function (32 and 64 bit)
2049 How to display a message with sum of column
2050 How to group specific rows
2051 How to count cells with colored font
2052 How to find row matching two conditions (Array formula)
2053 How to find row matching two conditions (loop)
2054 How to find row matching two conditions (ADO+SQL)
2055 How to sum data with multiple conditions (SumIfs)
2056 How to sum data with multiple conditions (loop)
2057 How to sum data with multiple conditions (AutoFilter+Subtotal)
2058 How to sum data with multiple conditions (matrix formula)
2059 How to sum data with multiple conditions (Five different ways)
2060 How to search data in listbox
2061 How to remove certain rows in every worksheet
2062 How to fill an one dimensional array (tree options)
2063 How to pass text to a function and get array back
2064 How to create folders and subfolders
2065 How to create a current day folder automatically
2066 How to move certain emails to a subfolder
2067 How to send an e-mail with an image attachment
2068 How to transfer a range to array and output specific column
2069 How to create an own unique list (Office 365 and higher)
2070 How to find missing numbers (Office 365 and higher)
2071 How to check whether a certain value occurs in a column
2072 How to find first/last appearance of number
2073 How to write multiple formulas in array and then fill downwards
2074 How to react when the formula result of a cell changes
2075 How to import numbers from cells as text into an array
2076 How to name a range of cells and put them into an array
2077 How to read the value of the CutCopyMode property, see Direct window
2078 How to fill a list box without duplicates
2079 How to determine missing invoice numbers
2080 How to color all numeric characters (0-9) in a cell
2081 How to insert random numbers by formula and freeze them afterwards
2082 How to fill a combobox in a userform with only one line
2083 How to perform a search for a date when the date is a formula
2084 How to perform a multiple search for a specific date
2085 How to insert a hyperlink without jump address
2086 How to run a loop backwards through a range
2087 How to process a range cell by cell from top to bottom and right to left
2088 How to replace any text in a text file and save it as a new text file
2089 How to detect missing numbers
2090 How to write the first / last day of each month for the current year respectively
2091 How to create a annual Calendar
2092 How to use the AutoFill function with "Copy"
2093 How to fill the AutoFill function with months
2094 How to address the flash preview of Excel via VBA
2095 How to tranfer text with autofill function
2096 How to write the month names as an array using a function
2097 How to compare the contents of two columns with the function StrComp
2098 How to determine the surrounding area of a cell (V1 + V2)
2099 How to copy a range and paste it into another table (V1 - V3)
2100 How to debug the path and filename of all open Workbooks
2101 How to create a contiguous area from two cells
2102 How to transfer only filled cells of a column to another table
2103 How to check if rows are added or deleted
2104 How to list CSV-Files in a Folder
2105 How to detect the current region of a cell
2106 How to read out the decimal separator used
2107 How to uncheck all CheckBoxes (ActiveX) on all tables
2108 How to remove all checkmarks from checkboxes (form control) on all tables
2109 How to import a CSV file into a table (QueryTables.Add)
2110 How to catch the abort or no input in an InputBox
2111 How to write a formula (=SUM) into a cell
2112 How to using the KeyPress event to enable only numbers for input in a TextBox
2113 How to use the KeyPress event to enable only numbers
2114 How to find texts in a ListBox via a TextBox
2115 How to remove all spaces in a column
2116 How to remove double spaces in a column
2117 How to remove double spaces in a column
2118 How to send mail after clicking the cell B1
2119 How to find first and last line in a specified range
2120 How to find first and last column in a given range
2121 How to fill dictionary with unique values and write back to sheet
2122 How to find first row of every number if a certain column is filled
2123 How to find first and last cell in a specified range
2124 How to write a cell with a line break
2125 How to remove all data rows from a ListObject
2126 How to create a email with help of a function
2127 How to search a listobject for a unique term
2128 How to add a total row to a list object
2129 How to read a text file line by line and write in the immediate window (FSO)
2130 How to get the number of a specific character in a string
2131 How to determine the row and column number of a button
2132 How to jump to a specific column based on a button position
2133 How to copy data from one table to another (different column order)
2134 How to check if a date falls on a weekend (function)
2135 How to remove certain characters from a string and replace them with blanks
2136 How to only copy filled cells to another worksheet
2137 How to format chart (line and background)
2138 How to insert a chart and dock it to a cell
2139 How to add chart and change format
2140 How to show userform with all worksheet names in ListBox
2141 How to export a diagram object as a graphic
2142 How to export all diagram objects in the folder as a graphic
2143 How to extract characters between two default characters
2144 How to select all visible cells in a range
2145 How to select all visible columns in a range
2146 How to determine the respective national language
2147 How to query the country code of a country
2148 How to read cell by cell from a closed workbook without opening the workbook
2149 How to load several non-contiguous areas into an array without gaps
2150 How to insert multiple hyperlinks with jump target to other tables
2151 How to work through cell by cell from the last to the first cell
2152 How to remove duplicate data from area
2153 How to create a string with separator (comma) from multiple cell contents
2154 How to accessing a text file with ADO & SQL
2155 How to access a text file with ADO & SQL, extract specific data and output to a table
2156 How to fill a array, extend it by one column and output it again
2157 How to create a cell dropdown dependant on input
2158 How to download a file directly from the Internet (API)
2159 How to load a file from the Internet (WinHttp)
2160 How to work with Evaluate to promote column no's into an array
2161 How to use the Like operator to check whether a string occurs in a string
2162 How to only extract numbers from a string
2163 How to sort and output an array using an ArrayList
2164 How to populate a ListView from a table and write all selected entries to a table
2165 How to sort and output an array
2166 How to sort and output an array of several columns of a range
2167 How to find the first free cell in a column (SpecialCells or End)
2168 How to find the first free cell in a row (SpecialCells or End)
2169 How to get data from closed file under check. Whether the correct provider is in use
2170 How to get the name of the most recent file in a folder
2171 How to get the name of the oldest file in a folder
2172 How to insert several rows based on sales seperated by semicolon
2173 How to get a specific column from an array and output it
2174 How to write data in a closed excel file
2175 How to process cells from different tables in one array
2176 How to identify/remove specific rows in a table with wildcard and like
2177 How to insert and uniquely name a new table in a folder
2178 How to create a named area (Name property, method Names.Add )
2179 How to group or ungroup rows
2180 How to specify range with criteria for filtering
2181 How to specify range as criteria for filtering (numbers only)
2182 How to use filter criteria from other worksheet
2183 How to import raw data into a report
2184 How to replace the minus sign on the wrong side (3 versions)
2185 How to leave only the yellow cells editable in all tables of the folder
2186 How to export a specific table as PDF and send it by e-mail
2187 How to populate a report with raw data
2188 How to allow printing only if a correct code is entered
2189 How to use the Benford test
2190 How to create an own time schedule
2191 How to play Bingo
2192 How to remove specific characters
2193 How to format a cell with a time format
2194 How to transfer the used cell of a column into an array
2195 How to transfer the used cell of a row into an array
2196 How to transfer the used range of a column to another sheet
2197 How to transfer certain columns from one table to another
2198 How to count a certain character in a string
2199 How to update data with the help of userform
2200 How to show all filtered data again
2201 How to copy a table, paste it after a specific table, and reference it
2202 How to populate an array from a table and extract specific row/column
2203 How to set a uniform zoom for all sheets
2204 How to insert apostropes in all selected cells if not already present
2205 How to insert a simple apostrophe in all selected cells, if not already present
2206 How to remove apostrophes in all selected cells
2207 How to perform a date conversion in all used cells in column A (CDate).
2208 How to perform a date conversion in all used cells in column A (DateValue).
2209 How to determine the used range of a table (V1, V2, V3)
2210 How to check whether a text from a cell occurs in an array
2211 How to call a user form with a copyable content (expand MsgBox)
2212 How to store a specific color in a variable and then apply it to a cell
2213 How to making colors "speak" with ENUM
2214 How to protect several columns dependant on the user
2215 How to deal with data validation
2216 How to take additional cells from a given cell
2217 How to copy a range and insert below
2218 How to set a new range based on active cell
2219 How to select a cell and resize a range
2220 How to transfer not empty cells to another sheet
2221 How to clear only numbers in a range (not formulas)
2222 How to fill empty cells with value below
2223 How to determine the width and height of an area (in points)
2224 How to insert a validity list with a reference to a range
2225 How to react on selecting a cell in column A
2226 How to move the first cell in the visible part of the window
2227 How to get the name and size of all files in a folder
2228 How to determine the number of filtered lines (V.1 + V.2)
2229 How to allow "own" input for all combo boxes of the table
2230 How to create and read an array as a constant
2231 How to fill an array with only one line of code
2232 How to fill an array with a title and a cell range
2233 How to read an address from a text file
2234 How to create a chart from an array
2235 How to function that extracts only numbers from a string (Custom function)
2236 How to create a function that extracts only numbers from a string (regular expressions)
2237 How to create a function that extracts only numbers from a string
2238 How to transport all unique texts from selected cells into an array
2239 How to output all unique texts from selected cells in the direct window (Dictionary)
2240 How to write all unique texts from one column to another column (Dictionray+Array)
2241 How to write a two-dimensional area in the direct window
2242 How to undo a filtering in a ListObject without removing the filter
2243 How to convert hexadecimal values to colors
2244 How to remove certain characters from a cell
2245 How to store a text in a byte array
2246 How to control a specific row in an array
2247 How to control a specific column in an array
2248 How to control specific fields in an array
2249 How to extract specific fields from an array
2250 How to define an ENUM with hidden entry
2251 How to not display certain macros in the "Macros" window of the "Developer Tools" bar
2252 How to call a function with an optional parameter
2253 How to increase zoom after clicking a cell
2254 How to select several columns (3 Versions)
2255 How to detect the position of several buttons
2256 How to detect and mark the position of a button
2257 How to write data automaticaly
2258 How to determine the visible area of an Excel window
2259 How to detect and output all filtered cells
2260 How to remove all data from a list object
2261 How to write formulas in an array, paste and fill downwards
2262 How to check a change of data
2263 How to start an automatic sorting of data
2264 How to read and write from /in a closed workbook
2265 How to write a one-dimensional array to a sheet
2266 How to write an array to a worksheet
2267 How to automatically select the text in a text box completely
2268 How to select one row and one column (crossair)
2269 How to export all shapes of a worksheet
2270 How to import a image
2271 How to fill an array from a table and play it back again
2272 How to fill an array from a table, determine and mark extreme values
2273 How to put an array into a cell
2274 How to output an array to a range
2275 How to rotate an array and output to a range
2276 How to copy, modify and delete an array
2277 How to copy, modify and delete a 2D array
2278 How to create an access to a named area via ADO&SQL
2279 How to create an access to a certain area via ADO&SQL
2280 How to extract specific data from a named range via ADO&SQL
2281 How to populate a multi-column list box using two nested loops
2282 How to extract specific data from a named range via ADO&SQL (from date)
2283 How to check if the active cell is within a range
2284 How to export a specific table to a new folder
2285 How to remove the cell colors in all tables of a folder
2286 How to round all numeric cells to 2 decimal places
2287 How to skip the first two lines when reading a text file
2288 How to read a text file only from a certain line (traditional)
2289 How to show the difference between DateValue and Cdate
2290 How to add a new row to a list object and insert data from range/array
2291 How to create a compiler-conditional pause function
2292 How to fill collection and empty again
2293 How to insert labels in a userform at runtime
2294 How to enter a date in a TextBox, add 14 days to it and output it in another TextBox
2295 How to use a function to check if a certain key is in a collection
2296 How to create and fill your own recordset
2297 How to create your own recordset and import multiple records from a sheet
2298 How to process a one-dimensional array field by field
2299 How to get the first position of a number in a string
2300 How to use the regular expressions to find the position
2301 How to define a recordset as criteria range and output specific records in other table
2302 How to remove all shapes in a table (except buttons)
2303 How to fill and read a dictionary array without duplicates
2304 How to fill a collection, insert a new entry and delete a specific entry
2305 How to recall the last action (e.g. input)
2306 How to check if an array has already been dimensioned
2307 How to determine and output file size in bytes
2308 How to determine and output file size in bytes (FSO)
2309 How to determine the first and the last cell in a cell area
2310 How to get the number of rows in a ListObject
2311 How to protect a sheet after opening the workbook
2312 How to get a confirmation whether an area should be deleted
2313 How to get the left cell of the active cell
2314 How to remove specific sheets from the workbook
2315 How to use an array in a user-defined function
2316 How to read properties of a file via the shell object
2317 How to determine creation date and author of the workbook
2318 How to fit a sheet to a printed page
2319 How to automatically adjust the column width after an input in a specific column
2320 How to automatically insert the change event after a sheet
2321 How to delete empty rows in a table
2322 How to extract the month from a date
2323 How to read a text file in a block and then pack it into an array
2324 How to enter a cell and check if there are any inputs in this row at all
2325 How to automatically fill an existing formula down
2326 How to search data in a listbox
2327 How to insert and resize an Excel chart object in Word
2328 How to determine the rows and columns in a named range
2329 How to call a listbox with its own title bar
2330 How to select multiple columns
2331 How to search in a listbox
2332 How to catch a runtime error when deleting empty rows when there are no empty cells
2333 How to get the name of the folder without the suffix
2334 How to fill a specific column in a ListObject with a default value
2335 How to delete all data except formulas in a list object
2336 How to delete all data in a list object (keep heading)
2337 How to get the name of the active table
2338 How to transpose a range without copy & paste
2339 How to rotate a range of cells using an array and insert it into another table
2340 How to insert a hyperlink and start a macro
2341 How to sort a range using an ArrayList and output to another table
2342 How to sort a range using an ArrayList and output it on another sheet with coordinates
2343 How to sort a numbers using an ArrayList
2344 How to automatically show the arrows to the involved cells for all formulas
2345 How to document all used controls of the table in a text file (name and position)
2346 How to detect the number of unique items
2347 How to automatically create folders according to the default from a sheet
2348 How to determine the number of a specified character in a cell
2349 How to determine the first/last day of a month
2350 How to convert the first letter in each cell to Large
2351 How to allow only numbers and a comma to be entered in a text box
2352 How to create a dropdown for multiple cells and feed them from an array
2353 How to use the FileDialog object to display a file open dialog
2354 How to filter a specific time period in a ListObject
2355 How to find the clicked button
2356 How to move a button
2357 How to extend a named area subsequently
2358 How to customize the formatting of the lines in a chart
2359 How to get the filter criteria for a page field of a pivot table from a cell
2360 How to remove the first field in an array
2361 How to split cell address in column and row
2362 How to colorize a row if condition is met (Resize)
2363 How to extract letters from cells
2364 How to output specific rows and contents in the direct window (Multiple contents)
2365 How to transport a named range into an array
2366 How to put a range together with its format in arrays and output it in another sheet
2367 How to check if a certain entry already exists in a dictionary
2368 How to use the same macro for all files in a directory
2369 How to compare columns with each other and append not "existing" values
2370 How to call a userform after double-clicking on a cell "near" the cell
2371 How to generate random numbers
2372 How to sum the value of a cell on several sheets
2373 How to transfer data from one sheet to another (ADO + SQL)
2374 How to transfer certain data from one sheet to another (ADO + SQL)
2375 How to group and sum data from a sheet by region (ADO + SQL)
2376 How to group data from a sheet by region and calculate monthly totals (ADO + SQL)
2377 How to call a user form without the close symbol (API)
2378 How to change a header from all files in a folder
2379 How to save the current session only if a cell has a specific content.
2380 How to compare two rows with each other (one-liner)
2381 How to convert all cells in a range to large (without loop)
2382 How to convert all cells in a range small (without loop)
2383 How to derive the month index from the month name
2384 How to create and traverse a multi-group array
2385 How to create a multidimensional array (short form)
2386 How to transfer a part of an array to another array
2387 How to get the first column from an array in each case
2388 How to create and traverse a multi-group array
2389 How to generate random numbers
2390 How to put together the possible combinations of two columns
2391 How to fill an array and compare the values
2392 How to remove a specific sheet from the folder
2393 How to close a user form via the ESC key
2394 How to define a function that determines a position
2395 How to remove all characters after a given character (Replace)
2396 How to remove all characters after a specific character (Split)
2397 How to determine the "normal" sheet name via the code name of the sheet
2398 How to concatenate multiple cells
2399 How to replace a specific text in a text file with another text
2400 How to debug.Print - switch rows on and off dynamically
2401 How to remove invalid rows in a sheet (AutoFilter & Delete)
2402 How to insert a new column in a ListObject and write formula
2403 How to check whether a folder has already been saved once
2404 How to remove all formula links to other folders
2405 How to call of another procedure incl. parameter transfer
2406 How to compose an e-mail with a diagram
2407 How to read the color value from a cell
2408 How to react after an input in a cell
2409 How to select multiple columns in a ListObject (Union)
2410 How to write the contents of specific cells to a CSV file
2411 How to save a range from a sheet in a new file
2412 How to freeze all formula cells of a sheet (values instead of formulas)
2413 How to search and mark a term in a column
2414 How to search and mark a term in a column (multiple search)
2415 How to search and mark a term in a column (multiple search)
2416 How to select and process a specific workbook from several open workbooks
2417 How to process the used area of a sheet without a title
2418 How to randomly select from default
2419 How to call a userform in the middle of the screen
2420 How to copy only cells with contents from one column and paste them into another column
2421 How to monitor specific cells in a column
2422 How to insert multiple rows before active cell
2423 How to check whether a data field is filled
2424 How to insert multiple columns after the active cell
2425 How to transfer certain data from one sheet to another
2426 How to document all changes in a column
2427 How to convert all PowerPoint files in a folder to PDFs
2428 How to get the position of items from another sheet
2429 How to get the position of items from another sheet
2430 How to get the position of items from another sheet
2431 How to subtract column totals from each other
2432 How to sum two columns together with Evaluate
2433 How to automatically mark multiple files in Windows Explorer
2434 How to transfer a column to another column and format it
2435 How to start and end a timer
2436 How to insert a text box at a specific location in a diagram object
2437 How to write multiple comma-separated values in cells in a column below each other
2438 How to get the scaling of a chart from named cells
2439 How to output the colors of the lines of a diagram in the direct window
2440 How to obtain the line colors for a chart from cells
2441 How to safe a workbook at the desktop
2442 How to download and save a specific file from the Internet
2443 How to detect extreme values together with the coordinate data in a range
2444 How to calculate the corresponding gross values with the help of an array
2445 How to transport a heading into an array, rotate it and output it again
2446 How to delete duplicate rows/data
2447 How to insert a comment with colored background
2448 How to insert and display a comment with image
2449 How to use an array to calculate gross value
2450 How to sort a birthday list using a arraylist
2451 How to detect duplicate data
2452 How to sort a worksheet after a data input
2453 How to dynamically summarize sales data of all sheets
2454 How to fill array from sheet and output rotated at another position
2455 How to fill empty cells in a range with zeros using an array and output them
2456 How to write the cell address of the smallest value in a range to cell
2457 How to write the cell address of the largest value in a range to cell
2458 How to perform a mean value calculation in an array
2459 How to calculate a conditional summation in the array
2460 How to remove all characters after the first space
2461 How to get last Monday from a given date
2462 How to filter a ListBox based on an input to a textbox
2463 How to colorize multiple non-contiguous rows
2464 How to colorize multiple non-contiguous columns
2465 How to process multiple non-contiguous areas
2466 How to search for a specific string in a range
2467 How to use the Split function to extract specific words from a text
2468 How to insert an overall frame for all connected cells of a sheet
2469 How to determine and check the frequency of numbers in a range
2470 How to insert and resize an autoshape in a cell
2471 How to remove a string completely from an entire range
2472 How to transport a comma-separated string into an array, enrich it and output it
2473 How to combine columns
2474 How to fetch a text from a comment
2475 How to control checkboxes
2476 How to automatically write multiple columns when capturing a cell
2477 How to insert a new column before a specific column and apply format
2478 How to call specific columns via a column name (ENUM)
2479 How to extract a decimal number from a text
2480 How to distribute multible words to cells (Horizontaly)
2481 How to distribute multible words to cells (Verticaly)
2482 How to select a specific Outlook folder from Excel
2483 How to remove duplicates if the combination of two column contents is the same
2484 How to insert a blank row after every third row
2485 How to insert a button directly into a cell
2486 How to conditionally select specific cells per row
2487 How to find the longest number in a string (regular expressions)
2488 How to remove all macros in a folder automatically at the click of a button
2489 How to extract a text that is in brackets (array)
2490 How to remove duplicates if three columns are the same
2491 How to remove all rows of code from a module that have a specific annotation
2492 How to fill a 1 based array and transfer it to another array
2493 How to split a date using an array
2494 How to search value in column with only one line of code
2495 How to process all subfolders based on a folder and import files into array
2496 How to download an Excel folder from the Internet
2497 How to download an Excel sheet from the Internet
2498 How to create one-liner to check if a string occurs in another string
2499 How to search a string in a string with "Like"
2500 How to show another inbox folder
2501 How to query data from a smart table via SQL & ADO
2502 How to query multiple regions from a sheet via SQL & ADO
2503 How to read the coordinates of a grouped shape
2504 How to using symbols as images for buttons in userforms
2505 How to insert and name a new column in all columns with a specific title
2506 How to transfer the format and formula of one cell to another cell
2507 How to filter data with an array
2508 How to fill cells containing letters with a zero
2509 How to transfer only cells with numeric content to other column
2510 How to transfer only cells with numeric content to other column
2511 How to sort a sheet by columns
2512 How to select a cell range with the help of an InputBox
2513 How to copy a shape and paste it specifically into another sheet
2514 How to process a one-dimensional array and insert certain entries into another array
2515 How to process a multidimensional array
2516 How to check if a cell is equipped with a conditional format
2517 How to reacht in double click on cell
2518 How to break down a column and create and fill multiple rows
2519 How to make a zero-based array a 1-based array during the runtime of a macro
2520 How to remove duplicate comma-separated values from cells
2521 How to create a user-defined function to sort a one-dimensional array
2522 How to border usedrange
2523 How to remove all buttons
2524 How to replace certain formats in the whole column
2525 How to filter from a specific date in a worksheet
2526 How to create multiple folders and subfolders based on one worksheet
2527 How to remove all letters and spaces from a string
2528 How to extract a part from an entire area and process it further
2529 How to interact between collection and array using the example of a range
2530 How to create a function that checks if a whole row has been "marked"
2531 How to check if a whole row was selected
2532 How to check if a whole column was selected
2533 How to remove the last part of a path and file specification
2534 How to copy all files from one folder to another folder
2535 How to read formulas from a ListObject into an array
2536 How to determine missing and duplicate numbers
2537 How to store specific sheets from a folder as separate folders in a folder
2538 How to place all Excel workbooks from a folder in a new folder
2539 How to read out the number of code rows in a project
2540 How to count all comment lines in source code
2541 How to transfer a conditional format
2542 How to extend a ListObject by a new row (fastest method via Resize)
2543 How to fill array with a consecutive, numbered list and output vertically to worksheet
2544 How to fill array with a consecutive, numbered list and output horizontally in sheet
2545 How to rearrange certain columns of a worksheet with the help of an array
2546 How to equip a list box with a link
2547 How to split a text based on a separator and query the first/last part
2548 How to set switch to be able to insert sheets
2549 How to remove empty cells in multiple columns (move up)
2550 How to transfer a cell content to a text field of a presentation
2551 How to do the principle of optional parameters for functions
2552 How to calculate Values in an array
2553 How to filter cells after cklicking Ctrl + m
2554 How to read array and output to worksheet
2555 How to insert several non-contiguous ranges in an overall sheet one below the other
2556 How to remove invalid data after filtering
2557 How to count page breaks and determine position
2558 How to distribute multiple quantity entries in cells to multiple rows
2559 How to create a diagram from an array and set diagram properties
2560 How to perform a currency conversion from EUR --> zloty in an array
2561 How to populate an ArrayList from a sheet and remove certain entries
2562 How to populate an ArrayList from a sheet and remove duplicate entries
2563 How to sum the contents of a one-dimensional array
2564 How to sum the contents of a multidimensional array
2565 How to get the postal code from a text (regular expressions)
2566 How to create a user-defined function to extract a 5-digit number from text
2567 How to get the number of specific numbers in the array
2568 How to call the "Macro Security" dialog with the ExecuteMso method
2569 How to call the macro recorder by macro
2570 How to call the Add-In Manager via macro
2571 How to show and hide the ribbons (toggle function)
2572 How to call the VBA development environment via the ExecuteMSO method
2573 How to generate important Characters Using the CHR Function
2574 How to convert the selected cells via an array large
2575 How to extract two numbers from a text (regular expressions)
2576 How to reference the "offset cell" in a loop in each case
2577 How to use previously defined colors for a "traffic light
2578 How to work with the sum product in an array
2579 How to deactivate all contour boxes in a specified area of the sheet
2580 How to call the "Folder selection" dialog via the shell object
2581 How to correct addresses via an array
2582 How to fill array and output horizontally or vertically
2583 How to create a whole matrix via an array and insert it into sheet
2584 How to assemble a complete matrix via an array and insert it rotated
2585 How to create an array from an empty area and fill it afterwards
2586 How to calculate the contribution margin from a table in an array
2587 How to calculate a total sum per category in an array
2588 How to calculate the average value of sales figures per employee in the array
2589 How to calculate a range of sales and its derivation
2590 How to perform multiple calculations (sum, contribution margin in the array.
2591 How to insert the current set color in the "Fill color" dropdown (yellow)
2592 How to create a function which checks for capital Letters
2593 How to fill empty cells in a range with the values above them
2594 How to pass an array of duplicate values to a dictionary
2595 How to write an array row by row and column by column in the direct window
2596 How to write an array row by row and column by column in a text file (FSO)
2597 How to determine last occupied row in two columns
2598 How to reset the filter criteria in the data filter
2599 How to reset the filter criteria in the data filter
2600 How to remove all totals rows in a worksheet
2601 How to transport the names of all worksheets in a folder into an array
2602 How to transfer colored cells into another worksheet
2603 How to query specific data from a worksheet and output it sorted
2604 How to mark the current month in a line chart
2605 How to create a one-dimensional array
2606 How to use a "quicksort" to sort a one-dimensional array
2607 How to sort a one-dimensional array via an arraylist and play it back into an array
2608 How to transform a range of cells into a one-dimensional array
2609 How to transform a cell range into a one-dimensional array
2610 How to search one-dimensional array using the Match function
2611 How to search a two-dimensional array and outputting the "found" locations
2612 How to search whether a certain number occurs in a two-dimensional array
2613 How to perform a search in an array and output the "found" location
2614 How to query the position of a value in an array via a function
2615 How to determine the size(s) of a three-dimensional array
2616 How to fill a three-dimensional array
2617 How to fill a three-dimensional array and distribute data to worksheets
2618 How to extract a specific column or row from an array
2619 How to transfer a range in a table 1:1 to another range via an array
2620 How to create a sorted unique list from customer number and customer name
2621 How to fill text marks in Word from Excel incl. Checkboxes
2622 How to define an array as a constant and then reload it into another array
2623 How to fill a collection
2624 How to output a two-dimensional array in the direct window
2625 How to output a multidimensional array well readable into the direct window
2626 How to create a chart not from a range of cells but via an array
2627 How to merge two one-dimensional arrays
2628 How to merge two two-dimensional arrays
2629 How to transfer a data field row by row into another array
2630 How to output the conditional format of the cell in the adjacent cell
2631 How to transfer the used range in one column to another worksheet
2632 How to use a cell to control whether several rows are to be hidden
2633 How to remove the path specification in a column
2634 How to increment the value of several cells
2635 How to remove specific lines from a line chart
2636 How to check whether all checkboxes in a user form have been checked
2637 How to set multiple filters and paste filter result to new worksheet
2638 How to set the maximum row height and column width for the entire worksheet
2639 How to remove only specific cells in a column
2640 How to get the three smallest/largest values from an array
2641 How to insert an image from the Internet directly into Excel
2642 How to insert a formatted text box into a worksheet
2643 How to get the first and last available cell of a row
2644 How to get the first and last available cell of a column
2645 How to check if a captured value in a cell is in a certain value range
2646 How to insert a formatted Excel range into a Word document
2647 How to output the size of the Excel screen in points
2648 How to fill dropdown from sheet
2649 How to insert a shape into a diagram object over its entire length
2650 How to add a new line in a list object
2651 How to use ADO and SQL to group sales by numbers
2652 How to use ADO and SQL to group sales by cost center and month
2653 How to group sales by employee and month and output in other worksheet
2654 How to use drag & drop with two list boxes
2655 How to execute and save query
2656 How to adjust diagram size
2657 How to return the number from an array that is closest to it
2658 How to copy sheets of all workbooks in a folder to a new workbook
2659 How to sort a ListObject in descending order of turnover
2660 How to find the last empty yellow cell in a column
2661 How to insert an image into a cell comment
2662 How to insert a shape with gradient into a worksheet
2663 How to determine all possible combinations from two columns
2664 How to write the contents of the selected cells to a text file
2665 How to make an array available to a cell dropdown
2666 How to show and hide all shapes of a sheet
2667 How to perform a conditional count using the Dictionary object
2668 How to perform a conditional summation using the Dictionary object
2669 How to perform a search with the Match function
2670 How to read out a selected date from a dropdown
2671 How to fill a dropdown on a sheet with week names
2672 How to create an array, subsequently enlarge it and store a decimal value
2673 How to change a hyperlink at runtime of a macro
2674 How to only enter the last number in the new cell at a time
2675 How to copy range and paste in other sheet
2676 How to protect cells after saving the file
2677 How to copy filtered data to another worksheet
2678 How to move cell pointer after input
2679 How to stop a macro for 3 seconds
2680 How to filter some entries in a pivot chart
2681 How to link all selected cells together
2682 How to determine the result column in a pivot sheet
2683 How to use an array as a source for a validity list
2684 How to Import data from a closed workbook
2685 How to protect specific cells in all sheets of the workbook
2686 How to output unused numbers
2687 How to extract numbers from texts
2688 How to write multiple column headers with only one row
2689 How to fill empty cells
2690 How to address the used cells of a range in the last column
2691 How to use an array as filter criteria for the data filter
2692 How to call up named areas via a combo box
2693 How to merge certain rows
2694 How to create dependant dropdowns
2695 How to autofill data in a column
2696 How to show chart from worksheet in userform
2697 How to fill array with data from a sheet
2698 How to compare two arrays and store common numbers in third array
2699 How to provide sheet with a "hidden" password
2700 How to protect a workbook
2701 How to copy and paste multiple non-contiguous columns without gap
2702 How to transport multiple non-contiguous ranges into an array and output them
2703 How to find the first cell with a date in a range
2704 How to mark all cells that are larger than the average
2705 How to process multiple named areas in succession
2706 How to create PDF files in series
2707 How to show and hide rows
2708 How to filter out multiple regions from a sheet and transfer them to a target sheet
2709 How to write column and row titles over an array
2710 How to output total sales on weekends with a user-defined format
2711 How to use the SELECT CASE to classify regions into groups
2712 How to check if a sheet exists
2713 How to create a collection, fill it and output a value from it via a key
2714 How to determine the capital city of a given country
2715 How to set the reference to a library
2716 How to write a text file with only one row
2717 How to sort a specific column using arrays
2718 How to copy data of a sheet from one file to another file
2719 How to query the first/last cell in a column of a list object
2720 How to wrap a cell content in double apostrophes
2721 How to expand or shrink a range in a worksheet
2722 How to read the index, the name and the code name of all the worksheets in the file
2723 How to insert a button in a user form via a macro and linking it with a macro
2724 How to filter by multiple values
2725 How to insert image in header
2726 How to insert logo in sheet and scale according to zoom in page layout
2727 How to transfer data from Word bookmarks to Excel "bookmarks" with the same name
2728 How to unlock all cells with a conditional format and then protect the worksheet
2729 How to fill report with rawdata
2730 How to rewrite totals correctly
2731 How to rewrite totals
2732 How to hide all rows and columns that are not used
2733 How to calculate Net to Gross
2734 How to fill ListBox with List
2735 How to fill a list box from an array
2736 How to convert a whole range to uppercase
2737 How to format font using the web browser control
2738 How to obtain filter criteria from a ListBox
2739 How to determine the clicked checkbox
2740 How to extend a range using the Resize method
2741 How to rebuild the InStr function with Evaluate
2742 How to find the last row in a ListObject
2743 How to find the last column in a ListObject
2744 How to put all numbers from a column into double apostrophes
2745 How to convert all numbers from a column as text
2746 How to query the name of the workbook
2747 How to use a function to convert a string into an array
2748 How to query a password when opening the workbook
2749 How to write a formula with double apostrophes
2750 How to delete a specific file without confirmation
2751 How to delete a file using the FSO object
2752 How to create a new text file with the help of the FSO
2753 How to create a new text file and store the current time
2754 How to create a text file on demand and store current time
2755 How to open a text file and append entry
2756 How to process field by field in an array
2757 How to insert multiple shapes and link them with macro
2758 How to open a workbook without link query
2759 How to measure the runtime of a macro with the Timer function
2760 How to automatically react when a specific cell is changed
2761 How to automatically update all pivot sheets in a session
2762 How to activate first page of a multipage
2763 How to create several rows based on comma seperated entries
2764 How to create several rows based on comma via Function
2765 How to create reports from pivot spreadsheets
2766 How to create an access management with password
2767 How to get conditional sum for each number
2768 How to quote text
2769 How to process all Excel files in one directory
2770 How to process all Excel folders from one folder
2771 How to write all files of a folder into table
2772 How to insert an image and fit it to a specific cell
2773 How to copy a specific spreadsheet to all workbooks in a folder
2774 How to process filtered rows of a worksheet
2775 How to query via an InputBox which values are to be colored
2776 How to write a percentage value into a cell
2777 How to find the first value in a column for each number
2778 How to fill a dictionary with an array "unique" and output it
2779 How to remove multiple non-contiguous columns with only one line of code
2780 How to read specific fields from a ListObject and output them in the direct window
2781 How to write a one-dimensional array in a worksheet
2782 How to offer all visible worksheets in a list box
2783 How to copy only the filled cells to another worksheet
2784 How to adjust color of lines and "area" in a bar chart
2785 How to insert a diagram and dock it to a cell
2786 How to insert a chart into a worksheet, set chart type, and then format it
2787 How to read xml file and output in direct window
2788 How to call a MultiPage with colored background (image on disk)
2789 How to call a MultiPage with colored background (image already in folder)
2790 How to Switch off labels of ribbon icons
2791 How to set criteria for the AutoFilter via a user form
2792 How to query the country code in Excel
2793 How to read a xml file
2794 How to create dependant dropdowns
2795 How to fill a data field, extend it by one column and output it again
2796 How to load a file from the Internet (WinHttp)
2797 How to download a file directly from the Internet
2798 How to recursive search for files in all subfolders
2799 How to copy specific area and paste at the bottom
2800 How to cut certain rows and transfer them to another workbook
2801 How to remove specific rows from worksheet (AutoFilter)
2802 How to import a file
2803 How to mark first use of a number
2804 How to extract specific part from a cell after split
2805 How to automatically color a shape after an input into a cell (traffic light)
2806 How to fill a collection with contents from an array and then sum it up
2807 How to process non-contiguous areas of a table
2808 How to make empty cells in a range disappear
2809 How to detect the selection of columns and store them in an array
2810 How to copy a specific range of a table to another worksheet
2811 How to transfer non-empty cells to another table
2812 How to remove only numbers in a range (WithoutFormulas and text cells)
2813 How to take additional cells from a given cell
2814 How to start from a cell to form a "remote" area
2815 How to form a new area offset from active cell
2816 How to convert all formula cells of a table to fixed values
2817 How to assemble files
2818 How to compile files
2819 How to transfer format and value from one cell to another
2820 How to replace formulas with fixed values on all tables in a workbook
2821 How to fill a range in a worksheet with letters using an array
2822 How to find the smallest date in an array
2823 How to find the largest date in an array
2824 How to form random dates in array and output to worksheet
2825 How to find a date from a cell in an array and output the found location
2826 How to fill a dictionary with values between 1 and 100
2827 How to compare two arrays with each other
2828 How to query the coodinates and the worksheet name
2829 How to determine the associated cell
2830 How to get the coordinate and the corresponding worksheet name from a given cell
2831 How to insert a diagram and feed it from two arrays
2832 How to fill empty cells with underlying content
2833 How to check whether a certain row in a 2D array is filled or not
2834 How to preset certain cells with the help of arrays
2835 How to fill a two-dimensional array with a line of code and then output it
2836 How to call query dialog
2837 How to convert to UTF8
2838 How to send appointment
2839 How to fill an array, rotate it and output it again
2840 How to detect duplicates in one array and output them in another array
2841 How to detect and output duplicates in 2D array
2842 How to insert, group and align shapes
2843 How to insert and format a cube of a specific size
2844 How to insert a new row at the end of the data and perform a mean calculation
2845 How to insert a totals row dynamically at the end of the worksheet
2846 How to create an AutoText and output it in the secondary column
2847 How to format textbox in userform without input comma
2848 How to only allow integers and the BackSpace key as input in a TextBox
2849 How to convert data in memory
2850 How to convert data with Evaluate
2851 How to remove all rows that contain a specific character in a column
2852 How to control filter criteria via a dictionary (incl. wildcard)
2853 How to fill a dictionary with keys & values and then "empty" it into an array
2854 How to fill array and process only a part of it
2855 How to fill array, transfer to other array and output rotated
2856 How to extract a specific column from an array (sum of the current month)
2857 How to extract a specific row from an array (yearly sum of a product)
2858 How to extract a specific cell from an array (intersection of row and column)
2859 How to convert data with loop
2860 How to fill an ArrayList from a sheet, sort it and output it in the direct window
2861 How to populate an ArrayList from a sheet
2862 How to fill an ArrayList from a sheet
2863 How to fill an ArrayList from a sheet, sort it and output it in another sheet
2864 How to compile files via function
2865 How to mark certain sheets in a folder (array solution)
2866 How to apply the special filter with date criteria range
2867 How to split a string, store it in an array and output it field by field
2868 How to split an array specifically part by part
2869 How to replace a specific string with another
2870 How to put a frame around the used area of a worksheet
2871 How to automatically create a folder based on cell entries
2872 How to transfer certain columns from one sheet to another worksheet
2873 How to transfer certain columns from a table
2874 How to remove specific rows from a table (multiple criteria)
2875 How to list e-mail from the inbox or outbox
2876 How to color the same lines in a list object uniformly
2877 How to create a function that determines the last word
2878 How to replace text via function
2879 How to automatically move the cursor to column E
2880 How to set a conditional format automatically
2881 How to format a range with random colors
2882 How to fill a dropdown with a horizontal cell range
2883 How to create a timetable
2884 How to determine which button was used to call a macro
2885 How to adjust the underlying range of a pivot sheet
2886 How to preset a specific area with a number (Resize)
2887 How to calculate the sum of a certain row from a cell range
2888 How to transfer certain columns to other worksheet
2889 How to search for a text in column A and sum up the corresponding row
2890 How to place a copy of the folder on the desktop and remove all macros
2891 How to place the active sheet as a PDF on the desktop
2892 How to create a function that opens a Word document via a selection dialog
2893 How to program option buttons
2894 How to compare the columns of two sheets and count differences
2895 How to read and write dictionary & array
2896 How to remove multiple countries from a sheet (filter)
2897 How to only extract specific cost centers
2898 How to add a new column to an existing worksheet (array)
2899 How to add a new column to an existing sheet (SQL ADO)
2900 How to put a array in a textfile
2901 How to fill bookmark with image (Late binding)
2902 How to fill bookmark with image (Early binding)
2903 How to fill several combo boxes with the same data (array)
2904 How to remove empty cells and null cells from a smart worksheet
2905 How to transport selected cells of a sheet in groups of 4 to another sheet
2906 How to transfer a list object from one worksheet to another (including the headers)
2907 How to find the last row/column using the SpecialCells method
2908 How to find and output the last occupied row in a list object
2909 How to find and output the last occupied column in a list object
2910 How to add and fill a new column in a list object
2911 How to remove all rows where a cell is empty in any column
2912 How to remove all rows if there is nothing in column A
2913 How to check whether a cell belongs to a "SpillRange" (as of Office 365)
2914 How to store a range sorted in an array
2915 How to store a sorted range in an array and output it again
2916 How to store unique values in the array and output them again (as of Office 365)
2917 How to store unique, sorted values in the array and output them again (Office 365)
2918 How to use the new SEQUENCE function from Office 365 onwards
2919 How to read out all hyperlinks in the folder and output them in the direct window
2920 How to check if there is anything at all in the row of the active cell
2921 How to check if there is anything at all in the column of the active cell
2922 How to play an alarm sound (version independent - API)
2923 How to select a cell, automatically color columns in cell respectively
2924 How to create, sort and output unique list via collection
2925 How to creates a unique list from a list and outputs it to a cell
2926 How to determine and output faulty hyperlinks in a worksheet
2927 How to delete certain rows in a diagram (Art. 1 and Art. 10)
2928 How to interlock two data fields
2929 How to check whether a string occurs in another string
2930 How to work through the marked area row by row
2931 How to transfer a range into an array and process it field by field
2932 How to filter data from an array (spelling does not matter)
2933 How to filter data from an array
2934 How to filter data from an array
2935 How to create a new list without empty cell (array)
2936 How to create a new list and disregard certain rows
2937 How to use the "like" when searching names
2938 How to using the BubbleSort with an Array
2939 How to adjust the font color in a Shape object
2940 How to create a list of records (from-to)
2941 How to rotate 2 digits at a time and put them together again
2942 How to open all files, print a specific sheet and close it again
2943 How to calculate easter sundays
2944 How to set a sheet event for multiple sheets
2945 How to Set a sheet event for multiple sheets
2946 How to hide certain columns in a worksheet
2947 How to write a few rows in a Word document
2948 How to convert net amounts to gross amounts
2949 How to get the last date
2950 How to delete empty fields in array and output to worksheet
2951 How to subsequently enlarge and fill an array
2952 How to remove all filtered rows in a worksheet (AutoFilter)
2953 How to form a sum of cells with the help of AGGREGAT
2954 How to remove all data rows except the first data row in a Listobject
2955 How to remove all data rows in a list object (keep formulas)
2956 How to transport a specific column from a ListObject into an array and output it
2957 How to adjust the calculation function of the result row of a list object
2958 How to transport a specific column into an array and output it
2959 How to transport specific columns into an array and output them
2960 How to transport specific columns into an array and output them
2961 How to transport certain non-contiguous columns into an array and output them
2962 How to populate a data field from a worksheet and pass it to another procedure
2963 How to copy all blue sheets to a new folder
2964 How to convert a list object into a "normal" worksheet
2965 How to find the largest value in a column and output row number
2966 How to find the largest value in a row and output column number
2967 How to store the names of all list objects of a folder in a data field
2968 How to filling a list box with data from a list object
2969 How to transport a list object into an array
2970 How to transfer all data from a list object into an array
2971 How to transport a column from a list object into an array
2972 How to determine the last day of the month
2973 How to write a formula for the whole column (FormulaR1C1)
2974 How to get all files of a folder and x-subfolders
2975 How to read the connection arrows between individual shapes
2976 How to implement a conditional summation of data via a dictionary
2977 How to populate a three-dimensional array from multiple sheets
2978 How to fill a three-dimensional array from several sheets
2979 How to find the current date in column A (Match)
2980 How to find the current date in the first row (Match)
2981 How to create a user-defined function to determine the source of a pivot chart
2982 How to make the Intellisense with ENUM
2983 How to loop through all definitions of ENUM
2984 How to build your own data type with different variables
2985 How to use a conditional summation of data via a dictionary in for a list object
2986 How to remove the last row in a list object
2987 How to fill, output and sort a dictionary from a sheet without duplicates
2988 How to form a column sum in all sheets of a folder
2989 How to transfer a range into an array and then save it in a new folder
2990 How to process multiple columns of an array and calculate an average value
2991 How to process multiple columns of an array and calculate an average value
2992 How to export specific sheets
2993 How to query an article
2994 How to mark unique values
2995 How to mark duplicate values
2996 How to add new data series
2997 How to link and format diagram
2998 How to create a pivot table for months
2999 How to summarize and compress data
3000 How to summarize sales by cost center
3001 How to read array, adjust and write away
3002 How to import contacts
3003 How to increase font size of validation list
3004 How to check the existance of validation
3005 How to change the source area of the chart
3006 How to create an outlook invitation (Ics)
3007 How to mark non-empty cells
3008 How to insert hyperlink to last sheet
3009 How to customize chart scaling
3010 How to fill up customer numbers
3011 How to insert label into diagram object
3012 How to fill text field
3013 How to show and hide an area
3014 How to show and hide an area
3015 How to hide non-contiguous columns
3016 How to hide non-contiguous rows
3017 How to hide non-contiguous column pairs
3018 How to hide column and show columns
3019 How to remove certain rows from Sheet2 and insert them into Sheet3
3020 How to summarize sales only by specific cost centers
3021 How to only transfer records from a specific date
3022 How to only transfer records from a specific date
3023 How to only records from tomorrow + 7 days
3024 How to transfer text to clipboard
3025 How to detect input in a column
3026 How to write data before closing the workbook
3027 How to write text file
3028 How to write and save sheet without formulas in new workbook
3029 How to search invoice no.
3030 How to show selection dialog and save the selection as a hyperlink
3031 How to hide all sheets (except the current sheet)
3032 How to undo cell connection
3033 How to save all sheets as PDF on the desktop
3034 How to save current workbook as PDF on the desktop
3035 How to lock and mark all cells with formulas
3036 How to mark all cells with spelling errors
3037 How to update a pivot table
3038 How to name range in sheet
3039 How to name and hide range in sheet
3040 How to display "DATA" name
3041 How to move selected rows to a sheet
3042 How to find first free cell in column A V.1
3043 How to find first free cell in row 1 V.1+2
3044 How to call a userform
3045 How to call a Userform and fill a combobox
3046 How to find the current date in a list
3047 How to check if character length always has 4 characters V.1
3048 How to check if character length always has 4 characters V.2
3049 How to check if character length always has 4 characters V.3
3050 How to save list field selection to array
3051 How to detect first word in a sentence
3052 How to check validation of an email
3053 How to remove empty columns in selection
3054 How to remove empty rows in selection
3055 How to insert image in comment
3056 How to delete hidden sheets without confirmation
3057 How to download files from the internet
3058 How to list all files of an folder
3059 How to split a string by seperator
3060 How to remove all data from ListObject
3061 How to read first column of a ListObject into an array
3062 How to replace texts
3063 How to remove duplicates from the base of a column
3064 How to remove duplicates from base of two columns
3065 How to use integrated dialog
3066 How to replace text in text file
3067 How to insert checkbox in column B based on entries in column A
3068 How to search a list object in a specific column
3069 How to go through a ListObject row by row
3070 How to go through a ListObject row by row (visible rows only)
3071 How to work through a list object cell by cell
3072 How to work through a list object cell by cell
3073 How to determine the size of a list object
3074 How to customize the design of a list object
3075 How to process specific column in ListObject and search and mark text part
3076 How to process certain column in the ListObject new numbering
3077 How to insert filtered rows of a ListObject into another worksheet
3078 How to reset the filter in all ListObjects of the folder
3079 How to show all filtered rows in the list object again
3080 How to hide all filter arrows in the ListObject (except the first one)
3081 How to copy filtered rows in ListObject without heading
3082 How to copy filtered rows in ListObject without heading
3083 How to use a special filter in conjunction with a ListObject
3084 How to remove certain rows with the help of the AutoFilter
3085 How to show all empty rows of a filtering of the list object
3086 How to show all filled rows of a filtering of the list object
3087 How to remove ListObject
3088 How to convert ListObject to Range
3089 How to name ListObject after checking the name
3090 How to name ListObject after checking the name
3091 How to remove current row in ListObject
3092 How to remove all rows with price <50
3093 How to convert all ListObjects in current workbook back to ranges
3094 How to remove all empty rows in the ListObject
3095 How to remove all data from a ListObject V.1
3096 How to remove all data from a ListObject V.2
3097 How to extract the month from a date V.1
3098 How to extract the month from a date V.2
3099 How to extract the month name from a date
3100 How to extract the month with leading zero from a date
3101 How to extract the month with leading zero from a date
3102 How to extract the calendar week and year from a date
3103 How to get the column names in a ListObject
3104 How to query the name of a ListObject
3105 How to query the stored cell range of a ListObject
3106 How to copy the ListObject and paste it as fixed values in Sheet2
3107 How to copy a specific column of a ListObject and paste it as fixed values in Sheet2
3108 How to sort a named range in a ListObject
3109 How to determine the title row of a ListObject
3110 How to remove the result row in a Listobject
3111 How to filter by color in ListObject
3112 How to filter by font color in ListObject
3113 How to filter by symbols in ListObject
3114 How to filter by symbols in ListObject
3115 How to filter by current month
3116 How to filter by specific month V.2
3117 How to resize ListObject
3118 How to insert and name ListObject
3119 How to read and process ListObject in data field
3120 How to set totals in listobject
3121 How to set partial results in ListObject
3122 How to get the date
3123 How to determine data basis of a ListObject
3124 How to transferring the surrounding area of a cell into a ListObject
3125 How to format first column in a ListObject
3126 How to color the columns in a ListObject alternately
3127 How to color the rows in a ListObject alternately
3128 How to apply the default style for ListObjects
3129 How to add result row and switch function
3130 How to show and hide title row
3131 How to check whether a specific ListObject exists in a workbook
3132 How to check whether the active cell is in the ListObject
3133 How to insert data section for the operation of a ListObject
3134 How to save the selected range of a sheet as a PDF
3135 How to determine the smallest and largest date in a column
3136 How to save a fixed range of a sheet as a PDF
3137 How to set a border automaticaly
3138 How to Form unique list of all items
3139 How to filter special filters for specific items in ListObject
3140 How to create unique list (DAO)
3141 How to query all sales greater than 50 via DAO
3142 How to query all sales greater than 50 via DAO
3143 How to performing a conditional summation using DAO in an Excel spreadsheet
3144 How to Performing a conditional summation using DAO in an Excel spreadsheet V.2
3145 How to create unique list (DAO)
3146 How to pull the top 10 sales from a dataset
3147 How to set frame by condition
3148 How to transfer data from one ListObject to another
3149 How to remove a specific column from a ListObject
3150 How to sort a ListObject from the base of a column
3151 How to apply the data filter for multiple columns
3152 How to apply the data filter for multiple entries in one column
3153 How to apply the data filter for multiple entries in one column V.2
3154 How to query the content of the sheet and insert it into another sheet
3155 How to write the first 10 records from an SQL query to a worksheet
3156 How to search for a specific name in a ListObject
3157 How to convert Excel spreadsheet to XML
3158 How to extract and total specific commodity groups
3159 How to lock a sheet
3160 How to write data row by row to other sheet (ADO & SQL)
3161 How to send mails
3162 How to show and hide rows
3163 How to create a variable cumulative formula in a column
3164 How to call a form via double-click in the corresponding cell
3165 How to include ADO library
3166 How to apply special filter
3167 How to get all data from workbook/Sheet1
3168 How to template for getting data from another file without opening it
3169 How to opening a text file and retrieving certain data from this file
3170 How to start SQL query - Pull all data from Access
3171 How to transfer raw data into a report (ODBC)
3172 How to transfer raw data into a report (SQL)
3173 How to transfer raw data into a report (Array)
3174 How to transfer raw data into a report (Sum Ifs)
3175 How to form min value in array per column
3176 How to sum columns in array and output
3177 How to sum up rows in the array and output them
3178 How to read sheet into an array, rotate and output to another sheet
3179 How to consolidate monthly sales and output to 12 sheets
3180 How to calculate mean value for specific column in array
3181 How to calculate mean value for specific row in array
3182 How to calculate end date based on working days
3183 How to fill multi-column ListBox dynamically
3184 How to detect changes in a worksheet
3185 How to hide and show rows after clicking the toggle button
3186 How to remove duplicate data from each column
3187 How to change label of checkbox after editing cell
3188 How to call hyperlink dialog
3189 How to count unique entries in a ListObject
3190 How to provide several areas of a sheet with an enclosing frame
3191 How to separate the salutation from the name in a cell
3192 How to search for text in connected cells
3193 How to copy data from one worksheet to another after activating sheet
3194 How to copy formatted data from one sheet to another
3195 How to transfer data from one sheet to another using SQL
3196 How to insert date automatically
3197 How to remove all columns after column K
3198 How to determine all selected sheets
3199 How to preformat multiple areas (cell shading)
3200 How to use the Internet Explorer clipboard
3201 How to query Access DB and insert results
3202 How to summarize sales by cost center (ADO)
3203 How to export specific sheets
3204 How to create and control a progressbar
3205 How to create diagrams
3206 How to create diagram and staple to cell
3207 How to create diagram with north
3208 How to add new series to a chart
3209 How to increase the validation list (dropdown) V.1
3210 How to increase the validation list (dropdown) V.2
3211 How to access another file and extract data
3212 How to create random numbers
3213 How to get data from another sheet after input key
3214 How to insert object
3215 How to insert PDf
3216 How to perform the AutoFill function with steps of 5
3217 How to combine two columns with all combinations of numbers
3218 How to start form
3219 How to name and select a shape
3220 How to list all sound files
3221 How to unique entries in column A count
3222 How to color cell after double click
3223 How to write range into array. Then save to test file
3224 How to create a variable cumulative formula in a column
3225 How to make a conditional sum of data
3226 How to check whether a certain folder is located on the user's desktop
3227 How to create a folder automatically if it is missing (FSO)
3228 How to read the path to the user's Documents folder
3229 How to move a folder from the desktop to another directory (FSO)
3230 How to copy a folder from the desktop to another directory (FSO)
3231 How to delete a folder including all subfolders and files
3232 How to check if a certain file is on the desktop (FSO)
3233 How to check and rename a file on the desktop (FSO)
3234 How to copy and paste a file (FSO)
3235 How to remove a specific file from the desktop (FSO)
3236 How to find and mark the max value of a column multiple times
3237 How to execute SQL query on own workbook
3238 How to convert date
3239 How to report missing numbers in sheets "Part1" and "Part2
3240 How to detect missing and duplicate invoice numbers
3241 How to remove old incoming payments
3242 How to get account designations from another file
3243 How to get all data from a closed file
3244 How to enter a valid number in Column A
3245 How to get all projects in a given period
3246 How to add new worksheet to external file (ADO + SQL)
3247 How to write to closed file with ADO
3248 How to use ADO to fill a complete column in a closed file
3249 How to use ADO to fill a complete column in a closed file
3250 How to use ADO to fill a complete column in a closed file
3251 How to use ADO to write new labels in a file without opening it
3252 How to fill array and output to column
3253 How to fill array and output to row
3254 How to ensure that the AutoFilter is switched off
3255 How to show the AutoFilter for a sheet
3256 How to check whether the data filter for the active sheet is already displayed
3257 How to enable the AutoFilter only for certain columns
3258 How to show and hide the AutoFilter in a ListObject
3259 How to create a name with reference to a cell
3260 How to insert a new sheet
3261 How to insert monthly table
3262 How to create folder, insert, name sheet and save folder
3263 How to hide certain regions in a pivot table
3264 How to apply different colors and fonts
3265 How to read and output all shape names of a sheet
3266 How to insert conditional format
3267 How to unite areas and write random numbers
3268 How to find last occupied row
3269 How to find connected cells in sheet
3270 How to conversion of minus sign on the wrong side of the cell
3271 How to find the largest value in a list
3272 How to find the largest value in a list
3273 How to sort sheet by colors
3274 How to sort empty rows to the top
3275 How to remove certain rows from the worksheet
3276 How to insert new folder/new sheet
3277 How to delete workbook events
3278 How to search for formatted account
3279 How to count all decimals in a range
3280 How to count differences of two columns
3281 How to read data from a closed file
3282 How to read data from a closed file without opening
3283 How to read data from a closed file
3284 How to check if a specific file is already open
3285 How to use the FilePicker to open a file
3286 How to read mailbox
3287 How to create dropdown and fold down
3288 How to create a cell dropdown and fill it with an array
3289 How to create a cell dropdown and fill it with an array
3290 How to set multiple filters in columns
3291 How to use the AutoFilter with "from" - "to
3292 How to hide autofilter and filter all cities with "M*"
3293 How to get ADO access to own file
3294 How to initialize multiple non-adjacent areas
3295 How to print sheet for each day of the month
3296 How to select range via input box
3297 How to set hyperlink to select a whole row
3298 How to determine duplicate numbers from column G and insert unicate in column A
3299 How to convert dates in selection
3300 How to get data from a sheet
3301 How to show and hide unused columns
3302 How to replace part of a cell´s data
3303 How to create a validity list
3304 How to access another file and extract data
3305 How to access another file and extract data
3306 How to query data from ext. File
3307 How to query data considering several conditions
3308 How to create folders and subfolders
3309 How to mark incorrect references in a worksheet
3310 How to convert selected cells upper/lower
3311 How to insert formula and fill down
3312 How to read csv
3313 How to syncronize two cells with event worksheet_change
3314 How to output cell color in direct window
3315 How to transfer values from one sheet to another
3316 How to insert empty columns every fifth column
3317 How to transfer data in a report
3318 How to determine the three largest values per month
3319 How to filter data and copy to other sheet
3320 How to consolidate sales per number
3321 How to separate text from column and further process only certain info
3322 How to remove multiple cost centers from a sheet
3323 How to summarize multiple cost centers to groups
3324 How to find and color formulas
3325 How to find first empty cell in column A
3326 How to find first empty cell in column A (from below)
3327 How to detect all empty cells in a range
3328 How to determine all cells with formulas in a range
3329 How to determine all cells with formulas in a range
3330 How to determine all cells with numerals (without formulas) in a range
3331 How to determine all cells with numerals (without formulas) in a range
3332 How to find all cells with text in a range
3333 How to determine all cells with notes in a range
3334 How to get all cells with conditional format in a range
3335 How to determine all cells with validations in a range
3336 How to insert Ohm character
3337 How to determine HEX value of a color
3338 How to hide several rows after input in cell A6
3339 How to control a toggle button
3340 How to remove Ohm character
3341 How to after opening Workbook protect all sheets
3342 How to insert and name new sheet after checking existence
3343 How to compare areas and color "commonalities"
3344 How to empty multiple areas
3345 How to compare areas and color "differences"
3346 How to compare areas and color "differences"(cell by cell)
3347 How to compare areas and color and document "differences"(array)
3348 How to compare areas and color "differences" of several columns
3349 How to count rows in text file
3350 How to color range A1:D10 in sheet1 in the correct way
3351 How to send e-mail with hyperlink
3352 How to send e-mail with internet address
3353 How to create a pivot table
3354 How to transfer appointments to Outlook
3355 How to write data in protected sheet without unprotecting sheet
3356 How to compress data array
3357 How to header and footer (font+size)
3358 How to addressing a sheet via a variable
3359 How to scroll screen automatically
3360 How to link diagram with data
3361 How to selecting a cell via an InputBox
3362 How to transfer text from a string, starting from a certain position
3363 How to detect visible cells
3364 How to format row in chart object
3365 How to find and remove specific row
3366 How to find and mark specific rows
3367 How to remove specific columns
3368 How to remove rows with texts
3369 How to allow autofilter in protected worksheet
3370 How to insert and align image
3371 How to address two non-contiguous columns in a range
3372 How to mark used cells
3373 How to format multiple columns
3374 How to extract last number from cell
3375 How to create a text file and write a row
3376 How to read special directories from Windows
3377 How to read out the name of the current file
3378 How to read out the name of the current file V.2
3379 How to determine parent folder of a folder
3380 How to create text file, write row, close. Then open again and append sentence
3381 How to write a text file with text and some blank rows
3382 How to create a text file with multiple rows
3383 How to write two lines in a textfile, open again and skip the first line
3384 How to skip characters in a row in a text file
3385 How to group columns
3386 How to fill a listbox
3387 How to group weekends
3388 How to send PDF by e-mail
3389 How to transfer text in textbox (multiline)
3390 How to select multiple sheets
3391 How to protect all worksheets, allow only formatting data
3392 How to print Data as one page
3393 How to fill empty cells in range with zeros
3394 How to process multiple ranges and mark empty cells
3395 How to process multiple areas and mark 0 cells
3396 How to fill two dropdowns with data from a sheet
3397 How to insert random numbers without duplicate numbers in range
3398 How to insert random numbers without duplicate numbers in range
3399 How to move Shape to the right side
3400 How to move Shape downwards
3401 How to compare two ranges cell by cell
3402 How to compare ranges and output the differences
3403 How to determine unique numbers and output to a sheet
3404 How to export a worksheet as textfile
3405 How to write text file with semicolon as separator
3406 How to make a shape move around
3407 How to check two columns from duplicate values
3408 How to check two columns from duplicate values
3409 How to remove empty columns in worksheet
3410 How to remove empty columns in worksheet
3411 How to convert text to cell selection small
3412 How to convert text to cell selection large
3413 How to convert every first letter in cell selection large
3414 How to convert every first letter in cell selection to uppercase
3415 How to prevent access to a given column
3416 How to prevent access to a given row
3417 How to prevent access to a given range
3418 How to prevent access to a range by demand
3419 How to insert a shape object to fill cells
3420 How to insert a Shape object to fill cells
3421 How to attach a macro to two shapes (on and off)
3422 How to transport data from rows to columns
3423 How to transport data from rows to columns
3424 How to create a dynamic area
3425 How to set the optimal width for an area
3426 How to set a specific column width for a range
3427 How to set a specific row height for a range
3428 How to work with operater like
3429 How to work with the Instr & LCase function
3430 How to get current info about the file
3431 How to detect current drive
3432 How to get the depth of a directory
3433 How to get the complete path of a textfile
3434 How to get the size of a folder
3435 How to close a workbook without saving it
3436 How to insert a shape after double clicking a cell
3437 How to insert blanks at specific position of cell
3438 How to show folder dialog
3439 How to show folder dialog (API)
3440 How to fill an array of cells, modify it and output it transposed again
3441 How to insert a Excel range into a blank Word document
3442 How to monitor a cell and change color of comandbutton automaticaly
3443 How to scroll current cell to left, top corner
3444 How to insert a cell from Excel into a Word document
3445 How to create a new subfolder in the Outlook Inbox named "new folder"
3446 How to allow filtering and grouping despite of sheet protection
3447 How to search a name in a column ( method match)
3448 How to search a name in a column ( method find)
3449 How to count characters without spaces
3450 How to remove empty subfolders
3451 How to fill area cell by cell ( click commandbutton several times)
3452 How to print several areas one after the other
3453 How to prevent a special range from printing
3454 How to replace special characters from address
3455 How to remove multiple characters in cells
3456 How to import headings into array and insert horizontally
3457 How to import headings into array and insert horizontally
3458 How to split and output multiple inputs in one cell
3459 How to extract largest value from a cell with multiple rows
3460 How to find the three smallest values in a range
3461 How to find the three smallest values in a range
3462 How to check whether the active sheet is locked
3463 How to format column A in currency format
3464 How to add a current appointment to the Outlook calendar
3465 How to read named range and locate first an last cell
3466 How to convert all formulas in the worksheet to fixed values
3467 How to convert all formulas in the sheet to fixed values
3468 How to convert all formulas in the sheet to fixed values (Entire sheet, cell by cell)
3469 How to fill empty cells with zeros automatically
3470 How to send current file by e-mail
3471 How to show and hide certain controls in a userform
3472 How to move a row from Listbox to textbox by drag & drop
3473 How to import data from CSV-file
3474 How to transport names of dropdowns into array and write to sheet
3475 How to make all hidden sheets visible
3476 How to search for a specific cell and address area above it
3477 How to create an array and fill it with random numbers and letters
3478 How to insert and format a TextBox in sheet
3479 How to add gridlines to a range
3480 How to rotate with minus character in a range
3481 How to invert selection in a specified area
3482 How to remove spaces in cells
3483 How to format all comments of a worksheet
3484 How to import text file
3485 How to save all modules to text files
3486 How to use the File Open dialog (single workbook)
3487 How to use the File Open dialog (GetOpenFilename)
3488 How to insert and format data label in chartobject
3489 How to customize the data markers in a chart
3490 How to customize the data markers in a chart (colors from cells)
3491 How to insert diagram and link to data
3492 How to address and format different areas of a diagram
3493 How to remove conditional formats in entire workbook
3494 How to find last used cell in column A
3495 How to find first free cell in column A
3496 How to process all files in one directory
3497 How to use the SaveAs Dialog
3498 How to count visible rows in list object
3499 How to determine the number of grouped sheets
3500 How to unfreeze Window in all worksheets
3501 How to set the zoom for all sheets
3502 How to format negative values by color red
3503 How to count all values on saturdays
3504 How to remove rows before a given date
3505 How to remove rows before a given date (AutoFilter)
3506 How to create export files (pdf + xlsx)
3507 How to read text file row by row
3508 How to replace several characters (replace)
3509 How to find and color the three smallest values in a range (Find)
3510 How to find and color the three smallest values in a range (cell by cell)
3511 How to format cells with cross-border
3512 How to debug print the first row in a multidimensional array
3513 How to print first 5 fields in the first column of a multidimensional array
3514 How to deal with an optional argument in a function
3515 How to add/ read/ remove a custom worksheet property
3516 How to use the secret object "VBA"
3517 How to determine windows-version (Win32 or Win64)
3518 How to calculate many cells without loop
3519 How to export and import a code module
3520 How to read/ write conditional formats
3521 How to fill matrix in "Export" worksheet
3522 How to transfer certain orders to another worksheet
3523 How to recognize and color the data range of a pivot table
3524 How to hide and show certain rows
3525 How to read color Ids and write them to columns
3526 How to detect first empty column in range
3527 How to detect first empty row in range
3528 How to select a range with help of the input box
3529 How to filter all dates after date in cell D1
3530 How to use an array to filter data
3531 How to color worksheet tabs after selecting a nr from cell A1
3532 How to determine whether two columns are equal
3533 How to hide red rows (format by conditional formatting)
3534 How to hide certain columns
3535 How to show and hide columns by demand
3536 How to jump to next worksheet
3537 How to read drive information
3538 How to list drive information
3539 How to list PDFs and word documents
3540 How to read and write a textfile
3541 How to read out inbox folder
3542 How to transfer multiple rows to another worksheet
3543 How to write specific data to another worksheet
3544 How to saw out a sheet and show all after
3545 How to format report(color highest and lowest value)
3546 How to Call dialog
3547 How to perform conditional summation with difference calculation using SQL
3548 How to group data by number and calculate average
3549 How to combine sheets and find missing numbers in sheet data
3550 How to fill empty cells with contents of the cell above them
3551 How to filter specific rows in the ListObject
3552 How to delete specific rows in the ListObject
3553 How to extract multiple spaces from cells
3554 How to extract multiple spaces from cells
3555 How to custom sort
3556 How to make group change visible
3557 How to Make group change visible
3558 How to show and hide red rows
3559 How to detect missing and duplicate invoice numbers
3560 How to split text and output first parts in debug window
3561 How to split text and output second part in immediate window
3562 How to define own window title
3563 How to determine min and max per month
3564 How to search for formatted account and take value from column A
3565 How to display a message on the screen and make it disappear
3566 How to start the NotePad via a VBS script
3567 How to find all spaces
3568 How to remove all spaces
3569 How to transfer validity list for ID sheets
3570 How to hide and show a range
3571 How to read and encrypt macro
3572 How to format the columns A-D as text
3573 How to search for string with case sensitivity
3574 How to determine min and max per month
3575 How to call dialog
3576 How to create print list
3577 How to call save dialog with present path
3578 How to fill range with random numbers
3579 How to format rows automatically
3580 How to process tables with specific color in tab
3581 How to set continuous page numbering
3582 How to move the cursor
3583 How to send email with HTML markup
3584 How to send email with HTML markup
3585 How to determine desktop V1+V2
3586 How to determine the amount of a special article
3587 How to read data from a xml-file
3588 How to change, edit, move rows in a listbox
3589 How to quote cell values
3590 How to protect worksheet creation
3591 How to search data in a listbox
3592 How to separate comment in several rows after doubleclick textbox
3593 How to filter array and count entries
3594 How to read data after opening as workbook
3595 How to search data in a userform
3596 How to replace multiple characters
3597 How to delete the next row of active cell
3598 How to delete next row of active cell
3599 How to check if folder is open
3600 How to set and read a custom sheet property
3601 How to calculate cells with and without loop
3602 How to reach and write conditional formatting
3603 How to transfer certain orders to another sheet
3604 How to write specific data to another table
3605 How to delete specific rows in the ListObject
3606 How to custom sort
3607 How to change cells with a leading apostrohe
3608 How to determine duplicate numbers from column G and insert unicate
3609 How to extract largest value from a cell with multiple rows
3610 How to summarize multiple cost centers to groups
3611 How to size up zoom by clicking cell
3612 How to save range from sheet as PDF and send by e-mail
3613 How to save range from sheet as PDF and send by e-mail
3614 How to transfer a range into an array and then save it in a new folder
3615 How to input data in column B and copy value to column A automatically
3616 How to empty all sheets in the folder (except for a specific Sheet).
3617 How to find a certain date in a column
3618 How to create and display a userform and a list box at runtime of a macro
3619 How to create a flexible printing of specific tables via a user form
3620 How to create and output a dynamic sum from a worksheet
3621 How to count all filled cells in a range
3622 How to count all empty cells in a range
3623 How to select all empty cells in a range
3624 How to detect all empty cells in a range write address to column K
3625 How to extract a date from a string
3626 How to set a range in a worksheet using second constants
3627 How to write a new row into a list object
3628 How to fill in the formula in a Listobject column from the first data row downwards
3629 How to find the next free column and form area
3630 How to extract special characters from a string and write it to immeadiate window
3631 How to conditionally fill a formula down (only fill if "empty")
3632 How to apply the conditional format "above/below" the average
3633 How to determine and color the three largest values per column
3634 How to turn expenses/income into Excel-readable numerical values
3635 How to close excel by leaving an userform
3636 How to generate random numbers, then draw one and mark finds
3637 How to filter data based on a search term
3638 How to hide the filter arrows for specific columns
3639 How to copy and paste all filtered data without heading and put it to sheet2
3640 How to check that only 2 decimal places are entered in a text box
3641 How to check input to textbox (only numbers allowed)
3642 How to check input to textbox (point not allowed)
3643 How to remove filtered rows from a list object
3644 How to send current folder as e-mail attachment
3645 How to get in a call after selecting a cell
3646 How to react after input data
3647 How to display date in a locked textbox
3648 How to convert not readable date
3649 How to react after input character "X"
3650 How to form a date from three columns (without loop)
3651 How to insert overall frame without title bar
3652 How to create an email with a clickable link to a web page
3653 How to check if special words are in an array
3654 How to covert all Worksbooks in a folder into text files
3655 How to detect left, top cell of a commandbutton
3656 How to fill data from left to rigth after input to cell B6
3657 How to change sevaral characters of a string to other characters
3658 How to fomat data vertically and horizontally
3659 How to determine the used area of a worksheet without a heading
3660 How to determine the used area of a worksheet without a heading (Resize)
3661 How to insert an overall frame starting from a start cell to an end cell
3662 How to initialize multiple named range with a 0
3663 How to remove all characters between a start and end character
3664 How to concatenate two columns (without loop)
3665 How to concatenate two columns (without loop, EVALUATE)
3666 How to concatenate two columns (array)
3667 How to determines the number of days remaining in the current year
3668 How to resize inserted image
3669 How to insert an image precisely in an area
3670 How to drag unique values from a column, sort and output them
3671 How to insert empty rows
3672 How to format all listobjects of a workbook uniformly
3673 How to create a listobject and assign format
3674 How to get the name of a listobject based on a cell within the listobject
3675 How to find formatted cells in range and then color the whole row of the found location
3676 How to reference to another cell after input in a given cell
3677 How to automatically select the first column when a cell is changed
3678 How to copy all Excel workbooks from a folder into one workbook
3679 How to copy all Excel workbooks from a folder into one workbook (All Sheets)
3680 How to create multiple emails based on a list
3681 How to link certain cell entries and combine them in one cell
3682 How to summarize certain cell entries together and write them into one cell
3683 How to remove specific tables from a workbook (CodeName)
3684 How to remove specific Sheets from a workbook (name)
3685 How to insert a dynamic sum formula at the end of a range
3686 How to list all files in the specified folder including subfolders in the direct window
3687 How to find the current date and then navigate to it
3688 How to set multiple countries as filter criteria (array)
3689 How to compare two rows with each other
3690 How to populate a report with raw data
3691 How to determine the three largest and the smallest values per month/product
3692 How to react in a range after double-clicking a cell
3693 How to list all workbooks from a directory
3694 How to remove duplicate data from 3 columns
3695 How to use a named range as filter criteria for a list object
3696 How to use a named range (from left to right) as filter criteria for a list object
3697 How to transport a string into an array and read the first and
3698 How to remove multiple columns in a range
3699 How to consolidate and output raw data to region/category
3700 How to customize the label of hyperlinks
3701 How to consolidate raw data to region/category and output V.1+2
3702 How to transport a string into an array and read the first and
3703 How to remove all characters between a start and end character
3704 How to import and open PDF
3705 How to call dialog (userform)
3706 How to start dialog to show help themes
3707 How to show and hide a specific multi-page via a ToggleButton
3708 How to query the name of the active image
3709 How to operate slicer (1 active, others all deactivated)
3710 How to set one slicer at a time and create one PDF at a time
3711 How to read all set slicers
3712 How to hide complete row if column A is null
3713 How to find and output extreme values for each number
3714 Non VBA solution with the functions MAXIFS and MINIFS
3715 How to find the largest / smallest value for each number (MinIfs, MaxIfs)
3716 How to determine the scaling for a chart object from cells
3717 How to import e-mail addresses from Outlook
3718 How to split a cell based on a separator and grab the first split
3719 How to split a text based on a separator and process it field by field
3720 How to filter a array with the help of a second array
3721 How to create an array, then add numbers and output again
3722 How to create a function that turns multiple names into valid email addresses
3723 How to generate email addresses from all employee names in a column
3724 How to show an userform after starting workbook
3725 How to use the FileDialog "FilePicker" to open a workbook
3726 How to query specific data using an SQL statement
3727 How to process all filtered rows one after the other
3728 How to query the protection status of all sheets in a workbook
3729 How to transfer certain sheets from a workbook to a new workbook
3730 How to save three cells A1, C1 and E1
3731 How to export all visible sheets and save them as a standalone workbook
3732 How to filter all records of a month
3733 How to highlight all records of the current month
3734 How to extract a spcial column out of an array
3735 How to resize an userform by dragging a corner of the userform
3736 How to resize an userform by dragging a corner of the userform (32 Bit)
3737 How to copy a range and insert to the next free column
3738 How to sum up ranges on several sheets and output them in one sheet
3739 How to perform a conditional summation using a dictionary and an array
3740 How to sort only the cells from a subrange of Excel
3741 How to transfer certain sheets from a workbook to a new workbook
3742 How to mark certain entries in a Listobject in a column
3743 How to remove specific columns in a range
3744 How to find and mark specific cells (numbers and texts) in a range
3745 How to frame all cells in a range
3746 How to display the last order in a userform
3747 How to transfer conditional format as "normal" formatting
3748 How to insert a shape and place it precisely to range
3749 How to dynamically color a "traffic light" shape depending on the input
3750 How to remove or set the fill area of a random shape
3751 How to sort a listview in a correct way
3752 How to create a new list with specified data (array)
3753 How to turn an uninterpretable "text date" into a valid date
3754 How to expand all pivot rows
3755 How to remove filter from page field of a pivot table and set default entry
3756 How to take a list object from one worksheet and insert it into another worksheet
3757 How to jump forward/backward one sheet in a workbook
3758 How to check whether the correct length is present in each case in a split array
3759 How to compare dictionary and arrays
3760 How to fill down data
3761 How to derive the first day of the month from the current date
3762 How to add a new row to a Listobject and fill it
3763 How to convert a CSV file to an XML file
3764 How to convert and output non-readable numeric values to other sheet using an array
3765 How to put an unreadable date into a special date format
3766 How to sort a list object by region and value
3767 How to sort a pivot table in descending order (rows)
3768 How to sort a pivot table in descending order (columns)
3769 How to sort a worksheet without title and totals row (Ascending)
3770 How to reduce a range by one column
3771 How to transfer range to PowerPoint
3772 How to transfer ranges from different tables into an existing PowerPoint presentation
3773 How to insert, position and save Excel area in new PPT presentation
3774 How to convert data
3775 How to process only the visible cells after filtering
3776 How to find duplicates from multiple columns
3777 How to copy a range and paste it into the next available column of another worksheet.
3778 How to replace specific content in a specific column on all sheets via a control sheet
3779 How to convert data automatically
3780 How to find and output extreme values per month
3781 How to use function VLOOKUP in event
3782 How to find actual month
3783 How to perform summation per employee/month
3784 How to fill a listbox (3 Versions)
3785 How to make the result of a sorted ArrayList available in an array.
3786 How to search contact folder by last- and firstname
3787 How to export contact folder to excel sheet
3788 How to save data from one sheet form to another using named ranges
3789 How to perform multiple search (2 Versions)
3790 How to calculate remaining capital
3791 How to set the column format for one or more columns
3792 How to fill two arrays, transfer contents from the arrays to a target array
3793 How to filter data using array
3794 How to mark the active row (keep previous format)
3795 How to create an e-mail with a hyperlink
3796 How to copy a specific shape to another sheet
3797 How to set multiple filter criteria using an array (alphanumeric)
3798 How to set multiple filter criteria using an array (dates)
3799 How to set multiple filter criteria using an array (numeric)
3800 How to repeat each row number on another sheet 3 times
3801 How to insert a Lamda function via VBA
3802 How to set multiple filter criteria using an array (3 Versions)
3803 How to format all label fields and the background of the shape with the color white
3804 How to link named cells in userform and save back again
3805 How to resize a range
3806 How to shrink a range by one row/column
3807 How to search for a specific field in the array
3808 How to search for a specific field in the array (XMATCH) as of Office 365
3809 How to perform multiple filtering of data with only one line of code
3810 How to hide columns with specific values
3811 How to refer from a named cell to a neighboring cell
3812 How to reference the first cell after the last cell in a named range
3813 How to fill and output a dictionary
3814 How to fill and output a dictionary
3815 How to insert a specific sheet (if it does not already exist)
3816 How to delete VBA codes
3817 How to extract the filename from a path
3818 How to get filename by formula
3819 How to summarize data with SQL
3820 How to summarize data with SQL without title row
3821 How to hide all empty rows in Listobject
3822 How to create a function that checks if the values come from a dynamic array
3823 How to create a unique ID
3824 How to set a conditional format with border, font and background color
3825 How to insert image into specific area of a sheet
3826 How to compare text
3827 How to draw three random persons from a list
3828 How to read current day emails from outlook
3829 How to delete whole row
3830 How to save attachments from all emails with the title "test"
3831 How to write random numbers to array and then output to worksheet
3832 How to write numbers to array and then output to a column
3833 How to write random names from a list to array and then output them to column C
3834 How to randomly determine 5 participants from a list
3835 How to monitor a cell and allow only certain numbers
3836 How to monitor a range and allow only stecial numbers
3837 How to monitor a range and send email after wrong data input
3838 How to prevent entering a range
3839 How to address only certain cells from a complete row
3840 How to address given cells of a whole row
3841 How to prevent selecting columns
3842 How to prevent selecting rows
3843 How to output contents of text file dbVersion.txt in direct window
3844 How to output contents of text file Data.txt to Sheet1
3845 How to find and mark these words in the doc1.docx
3846 How to input date in textbox
3847 How to add textboxes in userform by runtime of macro
3848 How to show input in textbox via label
3849 How to show current time in textbox
3850 How to insert and link TextBox
3851 How to write header and footer with special font
3852 How to conditionaly read a text file
3853 How to make a link for multiple cells to a specific column
3854 How to paste text from a cell into secondary cells
3855 How to insert the used range of a worksheet into a new PowerPoint presentation
3856 How to insert hyperlink in cell A1
3857 How to insert data into matrix with find method
3858 How to insert data into matrix with an array
3859 How to color double numbers with different colors
3860 How to color all cells with formulas (SpecialCells)
3861 How to attach Textbox to cell
3862 How to create workbook with monthly worksheets
3863 How to randomly determine 3 participants from a list
3864 How to combine keywords
3865 How to detect values of a consolidated cell using array
3866 How to react on double click to cell
3867 How to react on double click to cell
3868 How to insert random numbers with help of an array
3869 How to create random "date series" within a year
3870 How to create random "date series" within a year
3871 How to create random "date series" within one year and random values (array)
3872 How to read Windows environment variables
3873 How to output Windows directories in direct window
3874 How to split e-Mails by a given seperator
3875 How to react at right and double click
3876 How to read text file row by row and take over only certain columns
3877 How to create MSGBOX with three buttons
3878 How to read text file completely into string and output
3879 How to call InputBox with number input
3880 How to use inputbox with range
3881 How to delete double spaces between two characters using array
3882 How to delete double spaces between two characters using trim
3883 How to place multiple info in one section of the footer
3884 How to use advanced filter
3885 How to sum columns in array and output
3886 How to calculate mean value in array and write back
3887 How to execute SUMIFS in working memory
3888 How to copy chartobject to other sheet
3889 How to calculate mean value in array and write back
3890 How to execute SUMIFS in memory
3891 How to demand password by opening workbook
3892 How to read emails and open them by double clicking
3893 How to read mails from last days
3894 How to copy sheet before delete sheet
3895 How to delete double spaces between two words
3896 How to detect if a cell value is cleared
3897 How to detect cleaning of cell
3898 How to remove specific sheets from workbook
3899 How to set multiple filter criteria via an array (numeric)
3900 How to concatenate a range from another sheet in a cell
3901 How to extract first and last cell from a row
3902 How to respond to the click of the Cancel button on an input box
3903 How to remove specific names from the sheet (nme*)
3904 How to automatically adjust the column width of a column to the longest content
3905 How to adjust the print area in all sheets/workbooks of a folder
3906 How to dock a linked object to a cell
3907 How to read raw data into a report
3908 How to list all files of a folder in a sheet
3909 How to export specific sheets of a workbook, converting all formulas to fixed values
3910 How to read all Windows system variables into a sheet
3911 How to show and hide rows
3912 How to insert and fill two additional columns in a worksheet
3913 How to remove all rows of a worksheet where column A contains a formula
3914 How to transfer certain rows from one sheet to another sheet (AutoFilter)
3915 How to read out all individual shapes of a grouped shape
3916 How to clear multiple non-contiguous areas and cell with one command
3917 How to insert an image and scale it in a cell
3918 How to output first and last cell in a range
3919 How to insert a button into a cell with a perfect fit and link it with a macro
3920 How to generates a random number and outputs it horizontally or vertically
3921 How to format data
3922 How to color certain cells that lie in specified time periods
3923 How to loop through cells (V1-5)
3924 How to process a worksheet (V1-3)
3925 How to connect multiple arrays together
3926 How to process all shapes in a sheet via an array
3927 How to write a text in all "yellow" cells of a range (V1+2)
3928 How to insert image into cell and adjust
3929 How to transpose data (hang several columns below each other)
3930 How to automatically fill cells with missing numbers
3931 How to fit a sheet to a printed page and print it out
3932 How to mark only unique numbers
3933 How to use a partially qualified filter
3934 How to determine the sum of all sheets in the workbook
3935 How to jump from one month to another
3936 How to read conditional formatting colors
3937 How to filter data from Sheet1 and write to Sheet2
3938 How to create an appointment in the Outlook calendar
3939 How to (de)activate all checkboxes via a toggle button
3940 How to append numbers to textbox
3941 How to complete an input in all text boxes via doubleclick
3942 How to copy an Excel range and paste it, including formatting, into a Word document
3943 How to copy an Excel range and paste it linked into a Word document
3944 How to process data with EVALUATE
3945 How to change the font color of all selected cells by announcing an index
3946 How to convert a specified range of certain sheets into a PDF
3947 How to delete a specific sheet after confirmation
3948 How to determine and output the largest value per column in the array
3949 How to determine and output the smallest value per column in the array
3950 How to seperate a string based on a delimitor
3951 How to determine, output and mark the largest value per column in the array
3952 How to determine, output and mark the largest value per column in a range
3953 How to determine, output and mark the largest value per column in the array
3954 How to query the filled range of a column in a list object
3955 How to extract a specific part from a cell
3956 How to determine and output unique numbers from two columns
3957 How to automatically correct inconsistent formulas in a range
3958 How to determine the start and end date of a past quarter
3959 How to replace a value in several columns of a list object
3960 How to insert single cells of a range in another sheet in specific cells
3961 How to launch Microsoft Edge browser
3962 How to connect and format multiple areas
3963 How to move selection up and down via shortcut
3964 How to flag duplicate data (conditional formatting)
3965 How to set all regions one by one in the page field of a pivot table
3966 How to "pattern" all cells in a range
3967 How to open a web page with Micrsoft Edge and download an Excel workbook
3968 How to fill a dropdown with different data, depending on the selection
3969 How to prevent more than one cell from being selected
3970 How to identify the name and position of check boxes on a sheet
3971 How to increase an area by 20% when entering it
3972 How to create a function that count the day of a month
3973 How to keep the last mark in a workbook and restore it after opening it
3974 How to get data block by block using a key
3975 How to open a web page with Micrsoft Edge
3976 How to import and write back a database
3977 How to import and write back a database
3978 How to copy range and then sort column by column
3979 How to determine default settings
3980 How to read out special folders
3981 How to calculate average value
3982 How to scroll row by row and output to textboxes
3983 How to insert a diagram object via a function
3984 How to copy a flexible area several times (loop+without loop)
3985 How to create and display an e-mail with a file attachment (Early Binding)
3986 How to set a range based on a start and end cell and fill it with random numbers
3987 How to fill a range over only one formula with random values (New from Office 365)
3988 How to open a workbook, read the value and close the workbook again
3989 How to combine several areas on one sheet (short form)
3990 How to show and hide specific rows after selecting number
3991 How to remove filtered rows from a worksheet (without title)
3992 How to insert a Listobject by function
3993 How to remove certain column entries in a Listobject (Saturday + Sunday)
3994 How to determine the last day of a month using a formula (EOMONTH)
3995 How to assemble hyperlinks from selected cells and insert them into secondary column
3996 How to automatically mark filled cells in a range
3997 How to scroll row by row through listobject
3998 How to export a specific sheet and save it as a new file
3999 How to input data in listobject by userform
4000 How to read the screen resolution (32 / 64 bit)