Releasing Memory
Releasing Memory
(OP)
I'm using quite a bit of VBA code in a excel spreadsheet, and everytime the code executes, memeory usage goes up by about 100K, according to Task Manager. This memory is never released, and available memory just becomes less and less with each execution. Is there some procedure I can write at the end of my code to release the memory?





RE: Releasing Memory
Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
RE: Releasing Memory
RE: Releasing Memory
dim objRange as Excel.Range
blah blah magic code blah.
' we're done with the range, so clean up.
set objRange = Nothing\
Tim Grote - The Irrigation Engineers.
www.irrigationengineers.com
RE: Releasing Memory
Erase MyArray()
Set MyObject = Nothing
But it could be some of Excel problems as well.