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

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?

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

hi
are you using the windows clipboard in your proceedures? a lot of copy/paste
in a loop?

regards
FSt1

"Rgriff" wrote:

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?

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

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

set any arrays to null too

"Rgriff" wrote in message
...
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?