View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default how to redim more than one dimension in a multidimensional dynamic array?

Only the last dimension can be redimensioned in a dynamic array if you want
to preserve

Redim preserve arr(1 to 20, 1 to 30)

the data.

--
Regards,
Tom Ogilvy

"lvcha.gouqizi" wrote in message
oups.com...
As I searched previous posts, I get the point that only the last
dimension can be redimed. I am wondering what if both dimensions are
need to be redimed? I have a 4 dimensional array, and each dimension
has a big upperbound. If I define all of them to be fixed expect for
the last dimension, it will result in many unnecessary loops. Any
suggestions?

Thanks.