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