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


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


On 7$B7n(B24$BF|(B, $B8a8e(B3:30, Tausif wrote:
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/libr...ffice.10).aspx

Have a good read ;)

--
Tausif Mohammed



"pallaver" wrote:
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- $B0zMQ%F%-%9%H$rI=<($7$J$$(B -

- $B0zMQ%F%-%9%H$rI=<((B -