Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing Multidimensional Arrays? | Excel Programming | |||
Declare Multidimensional Arrays | Excel Programming | |||
Declare Multidimensional Arrays | Excel Programming | |||
Multidimensional Arrays - VBA | Excel Programming | |||
Multidimensional Arrays - VBA | Excel Programming |