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........

Erase MyArray

the behavior would depend on how you declared it. See vba help for details

--
Regards,
Tom Ogilvy

"JT" wrote in message
...
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........

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........