"ExcelMonkey <" wrote...
I just got my hands on Harlan Groves resizing code for arrays:

aresize()

My understanding of the code is that it allows you to change the size
of an array without affecting the date within the array (I think). I
was wondering if anyone can tell me what the limits of this function
are. That is, how many dimensions can it take How many rows can it
take? And any other limitation that I should know.

The only people of whom I'm aware have seen this code are Alan, myself and
anyone with whom Alan may have shared it. FWLIW, it's avalable at

ftp://members.aol.com/hrlngrv/arrays.zip

As for its limits, it should be able to handle anything VBA itself can handle.
When in doubt, test it and see for yourself.

--
To top-post is human, to bottom-post and snip is sublime.