Redim a multi dimensional array

[Geates]

I can't figure out how to dim and redim a multi-dimensional array while maintaining content. I have no issues with single dimension array. I've tried:

i=2
j=3

dim arr()
redim preserve arr(i, j)
error: Subscript out of range

dim arr(0,0)
redim preserve arr(i, j)
error: The array is fixed or temporarily locked

dim arr(,)
redim preserve arr(i, j)
error: Are you an idiot?

Any ideas (not pertaining to the last error)?

-Geates

 

[SkipVought]

hi,

Preserve Optional. Keyword used to preserve the data in an existing array when you change the size of the last dimension.

i=2
j=3

dim arr(2,0)
redim preserve arr(i, j)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[macropod]

Hi Geates,

You can only redim the last dimension of an array. That means you need to structure the array so that the dimmension that might need to be redimmed is the last one.


Cheers
[MS MVP - Word]

 

[Geates]

That's counter intuitive. Oh well, got it working. Thanx to both of you

-Geates