Out of Memeory

[Guest]

After performing one of my macro's multiple times (5-7), I get an error
claiming I am out of memory. When I debug the code to see what's up, I see
that I have just copied a series of objects. My thought is that I am coping
these objects, but never dump them out of my clipboard. Is there a way to do
this. or what is causing my problem?

Thanks

 

[Guest]

This site might get you headed in the right direction.

http://exceltips.vitalnews.com/Pages/T0596_Getting_Big_Macros_to_Run.html