Thread: arrays
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default arrays

Redim without the key word preserve wipes out the contents of an array... If
Tom's doesn't work for you. Depends how you created the array once again.

HTH

"JT" wrote:

I write data into an array. later on in the macro, I
write the array to a spreadsheet.

At this point, I want to clear the array. Is there an
easy way to clear an array after you are done with it?

Thanks for the help........