How to make a dynamic array with ReDim and Preserve?

[Snowmelt]

I was wondering how I can make an array that takes in integers, but have an endless array space so I don't have to limit my array in a for loop that ends in a large number

[Seth Schrock]

I would keep a global variable that stores the max subscript for your array. Each time that you need to add another element to the array, just increment that variable and then ReDim your array using the Preserve option.

intMAX_SUBSCRIPT += 1
ReDim Preserve intMyArray(intMAX_SUBSCRIPT)

intMyArray(intMAX_SUBSCRIPT) = 15  'my new number