Assuming the count in elem1 match the count elem2 (you'll always these 2
pieces of data together), why not use an array of custom types. e.g.

Public Type Data
Element1 as string
Element2 as long
End Type

Dim AllData() As data

redim AllData(1 to 10)

alldata(1).element1="Some value"
alldata(10).element2=5

redim preserve alldata(1 to 100)

NickHK

"Neal Zimm" wrote in message
...
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