Hi

You can use the Erase statement to reset the array in one shot. You'll have
to Dim the array again before using it. (See online help for Erase).

--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Max" wrote:

I have an array that I'd like to zero out each time I run the macro in Excel.
What would be a simple way of doing that?
--
Thanks!
Max