MultiDimensional Dynamic Arrays
 

Does VBA support MultiDimensional Dynamic Arrays? If so, can you tel
me how to set it up. If not, is there a backdoor way to accomplish th
same thing? Thank

--
TomR2
-----------------------------------------------------------------------
TomR29's Profile: http://www.excelforum.com/member.php...fo&userid=3206
View this thread: http://www.excelforum.com/showthread.php?threadid=51814

MultiDimensional Dynamic Arrays
 

Yes, but only one dimension, the last, can be dynamic.

You create like so

Dim ary

Redim ary (1 To 10, 1 To 15, 1 To 1)
'some code to determine what it should be
Redim ary (1 To 10, 1 To 15, 1 To n)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"TomR29" wrote in
message ...

Does VBA support MultiDimensional Dynamic Arrays? If so, can you tell
me how to set it up. If not, is there a backdoor way to accomplish the
same thing? Thanks


--
TomR29
------------------------------------------------------------------------
TomR29's Profile:
http://www.excelforum.com/member.php...o&userid=32064
View this thread: http://www.excelforum.com/showthread...hreadid=518140

MultiDimensional Dynamic Arrays
 

TomR29 wrote:
Does VBA support MultiDimensional Dynamic Arrays? If so, can you tell
me how to set it up. If not, is there a backdoor way to accomplish the
same thing? Thanks


Use collection class