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

variants and freeing bstr memory (C++) 2
Handling internet explorer memory leaks from Excel VBA 0
Rebuild hangs at end of step 5 0
Autonumber field in Excel that behaves the same as Access 0
How do i create and run an outside procedure? 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
Huge Memory Leaks using ODBC Drivers from Excel to retrieve data 7
write vba to a worksheet via a macro 3

Top