View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Mark Mark is offline
external usenet poster
 
Posts: 989
Default clearing array contents

Yes, when you use redim preserve you have to keep the lower bound
unchanged. But, since in your case you anyway want to throw away only
the values in the upper region of the array this technique should work.


I didn't want to get rid of the dimensioned element, just it's value.

The way I have it, the redim only rusn once... after the level count is
determined.

Thanks for the suggestions.

Good night.