out of memory running a macro...
Posted by rm on January 30, 2002 10:35 AM
I have a macro that works okay, but when I ran it on one occassion (yesterday), there was an "out of memory" error, and the sub crashed...is there a way in vba code to clear and reclaim memory so that this will not happen again in the future? I would like to place this command, if it exists, in a loop so that it will clean up memory before going to the next loop.
(Because this macro loops over several documents and takes a couple of hours to complete, I run it unattended, usually before leaving work for the day.)
Thanks for any advice!