View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Mark is offline
external usenet poster
 
Posts: 989
Default Efficient Arrays?

Efficient Arrays: Setting size equal to count?
If I have an array that, based on the data loaded to the program, could need
to be rather small(10) or very large (10000), if there a way to selectively
set the size.

If I made the array dynamic, can I redim = count where count is a variable
based on the number of rows in a column?

Or is there no harm in dim an array as very large an only using a small part
of it? Does the unused portion pose a large drain on resources?