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: 63
Default List Arrays of a Certain Size

I have a subroutine that uses a two-dimensional array to get data with which
I create a complicated chart. I would like to use this same subroutine on
about 25 other arrays of similar size, by just varying the name of the array
used by the subroutine. I am thinking of creating a listbox showing active
two-dimensional arrays, and plugging the chosen array name into the
subroutine. How would I get VBA to create a list of two-dimensional arrays
that currently exist in memory so that I could feed that list into a listbox?
Any ideas will be appreciated.
 
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
Drop Down List Size MMouse Excel Worksheet Functions 1 January 11th 08 10:14 PM
Regional settings independent list separator in arrays Vlado Sveda Excel Worksheet Functions 3 January 9th 07 01:19 PM
Macro to Sum Arrays of Various Size ConfusedNHouston Excel Discussion (Misc queries) 4 October 12th 06 03:03 PM
validation List Size Keith Excel Discussion (Misc queries) 1 October 11th 06 12:12 PM
List boxes, Arrays and Sorting Stuart[_15_] Excel Programming 2 December 23rd 03 06:49 PM


All times are GMT +1. The time now is 12:23 PM.

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"