I'm trying to create a dynamic array of data.

I had previously dimensioned at the top of my sub the following:
Public ItemArray(10,7) As Variant

This gets me what I want, but only for 10 entries. I may actually
have 50 entries.
How do you dimension an array such that the amount of entries
changes / is dynamic?

The array is currently inside of a loop for items, and I want the
array to update as below with each item.

Hopefully this is enough information to piece together what I'm
looking for.
Thanks, Neil


ItemCount = ItemCount + 1
ItemArray(ItemCount, 0) = ItemName
ItemArray(ItemCount, 1) = AAvariable
ItemArray(ItemCount, 2) = BAvariable
ItemArray(ItemCount, 3) = CAvariable
ItemArray(ItemCount, 4) = DAvariable
ItemArray(ItemCount, 5) = EAvariable
ItemArray(ItemCount, 6) = FAvariable
ItemArray(ItemCount, 7) = GAvariable