View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
pk pk is offline
external usenet poster
 
Posts: 27
Default free up memory by deleting variables

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
.