how do i release ram after running a procedure in excel?

  • Thread starter Thread starter Rgriff
  • Start date Start date
R

Rgriff

i created a workbook with several complex procedures and every time i run a
procedure it just keeps building more and more memory, and never releases it.
is there a way to release memory after procedure has been ran?
 
hi
are you using the windows clipboard in your proceedures? a lot of copy/paste
in a loop?

regards
FSt1
 
make sure that any objects are set to nothing once you finished with them

set any arrays to null too
 
Back
Top