View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Dana DeLouis[_3_] Dana DeLouis[_3_] is offline
external usenet poster
 
Posts: 690
Default Preserve keyword

You may want to look at the Collection or Dictionary objects.
Depending on what you are doing, they can sometimes simplify complicated
programming.
- - -
Dana DeLouis


LesHurley wrote:
Thanks everyone. For my present purposes I was able to calculate the
ultimate dimensions of the array before the ReDim and therefor no need for
the Preserve keyword. I'm sending a ParamArray List() to the function and in
this case the size of List() and of each member of it are known when the
function is called. I guess if I ever need more than that I will just write
it in C++.