Redim an array 2 dimensions

[mortphil]

Hi Everyone,

I iterate through a list and store the data in an array

Please Login or Register  to view this content.

This works fine, but I tried to have 2 dimensions to the array and It no longer works!

Please Login or Register  to view this content.

Would you have any ideas ?

[romperstomper]

If you use Preserve when you Redim you can only change the last dimension. I assume the real code is more complicated as there is no need for Redim here at all, so you may want to consider transposing the array so that you resize the second dimension.

[mortphil]

Thanks RomperStomper,

Yes I simplified my problem, There is about 7000 records and 3 dimensions but if I understand the logic on 2 I figured I could do it on more.
Basically per "row" in my array I have 3 info I want to store.
ideally I wanted to do
Dim preserve my array(x, 1 to 3)
etc Now I understand I can only resize the last dimension.
If I understand your suggestion properly I should do

Redim preserve myarray(1 to 3, x)

Thanks a lot for your help I am going to try that.

[romperstomper]

Depending on what you are doing with the array, you may also want to consider using an array of arrays. Then you only have one dimension for myArray so you can redim preserve as necessary, and simply assign an array to each element of myArray.

Also, please don't forget to mark the thread solved if you are happy with the answer.

[mortphil]

Both of your suggestions worked!

Thank you for your help.
-Phil