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