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: 10
Default Why use redim when creating an array of arrays?

I am working on a project where I need to do an array of an array. I've done
some reason, and see that the general approach is to create the sub-arrays,
and then set each of the sub-arrays equal to an element in the parent array.
I've seen two approaches, one being in the thread titled "jagged arrays", and
the other using the redim command titled, "How do you create an Array of
Arrays?".

I understand the first method, but I don't understand why the redim command
is used in the other. It seems a bit more complex, but does seem to be the
prefered method in all the articles I've read about this subject. Is there
some benefit I will be missing if I don't use the redim method?

Joe Dunfee
 
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
ReDim Array Brandt Excel Programming 3 October 9th 06 06:42 PM
ReDim Array Viktor Ygdorff Excel Programming 2 July 10th 06 04:04 PM
Creating a single vertical array from multiple column arrays Bryan Excel Worksheet Functions 2 December 10th 05 07:12 PM
ReDim Object array as parameter of Variant array Peter T Excel Programming 4 May 10th 05 02:11 PM
ReDim, Preserve and Multidimensional arrays Andy Westlake[_2_] Excel Programming 3 October 19th 04 07:04 PM


All times are GMT +1. The time now is 11:26 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"