Help with the ReDim command (please!)

[Hambone]

I have an array:

Dim MyArray (1 to 20, 9)

How can a Rediminsion the first part of the array?

Later in the code, I need to increase it's size to an unknown amount: (1 to X, 9)

The '9' never needs to change........ I tried a few different ways of using the ReDim statement, but none have worked.

BTW - I assume you don't loose data already stored when you do this?

Thanks for any help.

[dilama]

Actually you WILL lose data preforming a re-dimension this way. The proper way to re-dim an array follows :

Dim x() as string
Dim counter as long

for counter = 0 to 100
redim preserve x(counter)
x(Counter) = cstr(Counter) '(or whatever value you want)
next counter

Hope this helps.....

[Guv]

You can ReDim the last dimension without losing data.

Can you rewrite the code to allow the dimension you want to change to be the last one?