LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 345
Default ReDim an array AFTER it's loaded into another array

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA syntax help: ReDim Preserve an array Dave Excel Discussion (Misc queries) 4 September 8th 07 07:37 PM
ReDim Array Viktor Ygdorff Excel Programming 2 July 10th 06 04:04 PM
ReDim Object array as parameter of Variant array Peter T Excel Programming 4 May 10th 05 02:11 PM
Dim / Redim of an Array Fred[_17_] Excel Programming 4 June 28th 04 03:16 PM
ReDim an Array Art[_5_] Excel Programming 3 October 25th 03 03:30 PM


All times are GMT +1. The time now is 11:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"