MultiDimensional Dynamic Arrays

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

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" <TomR29.241axa_1141289401.8577@excelforum-nospam.com> wrote in
message news:TomR29.241axa_1141289401.8577@excelforum-nospam.com...
>
> 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
>

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