View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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