Multi Dimensional Array Question...

[eargo]

Is it possible to ReDim a multidimensional array? Ideally don't want to declare a 100 x 100 element array when I'm only going to use say 30 x 70 elements or something on average. Thanks

 

[SkipVought]

Yes,
Check out ReDim in Help. There is a caveat if you need to Preserve values in the array as you process. Skip,
SkipAndMary1017@mindspring.com

 

[MatthewGB]

As Skip said, the help section gives you some hints as to how to redim arrays. Note that when redimming you can only change the number of elements in the last array if you want to preserve the contents of the array. i.e. if you have your 100x100 array partially full of data and want to trim it down but keep the contents, you will only be able to redim the array to something like 100x50 or whatever. (not 50x100).

I use a particular method to get around this problem. If you want any further details dont hesitate to ask.

Matt