Tom,
Any guidance on using Erase (like Set Object = Nothing)? I had assumed a
program will release the memory when it completes.

Alex J

"Tom Ogilvy" wrote in message
...
Just to add,
That doesn't free up any memory if the array is not dynamic.

from help for Erase:

Reinitializes the elements of fixed-size arrays and releases dynamic-array
storage space.

--
Regards,
Tom Ogilvy

pk wrote in message
...
To clear an array use: ERASE

Erase myarray(13, 18)

HTH

-----Original Message-----

I have tons of variables in my VBA code and need to
delete some of them
when they're no longer needed. What's the code for
that? For
example, how do I delete myarray(13,18)? Thanks!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step
guide to creating financial statements
.