resetting Public Arrays in VBASIC
 

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

resetting Public Arrays in VBASIC
 

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