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

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

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

set any arrays to null too

"Rgriff" <(E-Mail Removed)> wrote in message
news:4DD0841A-D6DF-4468-B3AD-(E-Mail Removed)...
> 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?