View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default arrays in arrays

Thx for helping.
-----Original Message-----
I couldn't get this to work. Assuming you have something

like:

Dim a, b, c, d, z
ReDim a(0 to 2)
ReDim b(0 to 2)
ReDim c(0 to 2)
ReDim d(0 to 2)

a(0) = b
a(1) = c
a(2) = d

The syntax would be somthing like

Redim Preserve a(1)(0 to 8)

but it gives a syntax error and won't compile.

I had to do something like this:

z = a(1)
Redim Preserve z(0 to 8)
a(1) = z


On Fri, 27 Aug 2004 06:35:23 -0700, "jacob"
wrote:

Hi,
Have a 2D array where each element contain a new 2D
array. Is it possible to perform a 'Redim Preserve' on

an
array contained in the "mother" array? If so, what is

the
proper syntax?

Any help appreciated.


.