MultiDimensional Dynamic Arrays

[TomR29]

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

 

[Bob Phillips]

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)

 

[Kris]

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