ReDim Preserve & Multi-dimentional Arrays 1

[MacroManII]

Hi,

I have a multidementional array that I want to Re-Dimension and preserve the data. I have tried ..

Redim Preserve Myarray( 100, 20)

But this does not work ..

Help

MacroManII

 

[sunaj]

You can only (using redim) redimension the last dimension of a multidimensional array. Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'

 

[SonOfEmidec1100]

Also the initial dim must have no elements then be redimmed to the first values

Dim MyArray()
ReDim MyArray(10, 20, 100)


ReDim Preserve MyArray(10, 20, 200)


cjw