Can I reset an array to myarray()
 

Dan,

Use the Erase statement. E.g.,

Erase MyArray


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Dan" wrote in message
...
I want to clean out a public array that I have grown
dynamically and start over as if it was the first time into the
code.

ReDim myarray() gives an error message.