Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
HI All,
I have an array whose elements are other arrays. I use option base 1, and things are OK. Once a "master" array is formed, it looks like the component arrays cannot be re-dimmed. The ReDim VBA help is silent on this ability. in a procedu dim master(2) dim elem1() as string redim elem1(3) dim elem2() as integer redim elem2(3) values are put into elem1 and elem2 and then: master(1) = elem1 master(2) = elem2 I was testing trying to ReDim " elem1" and "elem 2" AFTER the master was "loaded". I get an immediate compiler 'red ink' error when I type: Redim master(1)(4) Note: ReDim master(3) to add another array does me no good. I guess I have to leave "room" in elem1 and elem2 before they are loaded into the master, or unload the master to the elemental arrays, ReDim them, and finally re-load back to the master. Am I correct, or is there another way? Thanks, -- Neal Z |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA syntax help: ReDim Preserve an array | Excel Discussion (Misc queries) | |||
ReDim Array | Excel Programming | |||
ReDim Object array as parameter of Variant array | Excel Programming | |||
Dim / Redim of an Array | Excel Programming | |||
ReDim an Array | Excel Programming |