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

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?
 
F

FSt1

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

regards
FSt1
 
P

Patrick Molloy

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

set any arrays to null too
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Huge Memory Leaks using ODBC Drivers from Excel to retrieve data 7
How do i create and run an outside procedure? 1
how do i release memory 1
variants and freeing bstr memory (C++) 2
write vba to a worksheet via a macro 3
Runtime Error '7': Out of Memory 3
Which textbox am I in? 1
Activating a renamed workbook 10

Top