Dynamic Array (multiple columns) Question

[pallaver]

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

 

[Tausif]

Hi,

A dynamic array can be used by delaring the line below.
Dim DynamicArray() As Long

& then re dimension it to number that you need (10,50 or whatever. )

ReDim DynamicArray(1 To 10)

Plz check this link on using arrays (static & dynamic)
http://msdn.microsoft.com/en-us/library/aa164778(office.10).aspx

Have a good read

 

[pallaver]

Couldn't find anything on 2 dimensional arrays, only single dimension
arrays.... Did I miss something there?

 

[Rick Rothstein \(MVP - VB\)]

You can get some additional information by typing ReDim in the Immediate
Window or in any code window then, with the caret (text cursor) touching the
word, press F1.

Rick

 

[Tausif]

You needed to check the create arrays section. Below is the exact link.

http://msdn.microsoft.com/en-us/library/aa140487(office.10).aspx