View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stratuser Stratuser is offline
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.