Dynamic Array in Excel VBA - Easy Excel Macros

If the size of your array increases and you don't want to fix the size of the array, you can use the ReDim keyword. Excel VBA then changes the size of the array automatically.

www.excel-easy.com