Out of Memory
 

I've had this occur recently (I'm on Excel 97).

I found that closing down the modules in the VBE helped,
so that only those you need are open.

Also, you may be encountering the 64k boundary limit (see
Help for more details) - in which case, split your macros
into smaller sections. I decided to have a controlling
macro that "called" other macros to do the work. I then
split the macros being called into smaller sections.

I found that it also helps with debugging.

HTH
-----Original Message-----
I'm troubleshooting an extensive macro which does a lot
of copy and pasting from one sheet to another. When I try
to debug it and copy code I recieve an Out of Memory
message. In order to clear it I have to close excel and
reload at which point I am able to copy and paste, at
least until I re-run the macro. Is there a way to clear
the memory in code or while I'm debugging? I'm running
excel 2000 on win2k3 with 2gb ram.

Thanks

.