array resizing

[Luis939]

I have this 2-dimensional array that i declare

dim myarray(1 to 10, 1 to 10)

however, it doesnt seem possible to "Redim" this array, apparently you can only do that for 1 dimensional arrays...
But does anyone out there know how this could be achieved?
Thanks!!!

 

[combo]

You can ReDim only dynamic array:
Dim MyArray()
...
ReDim MyArray(1 to 10, 1 to 10)
Only last dimension size can be resized with Preserve keyword:
ReDim Preserve MyArray(1 to 10, 1 to 15)

combo