This site might get you headed in the right direction.

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

"Pete" wrote:

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
--
Pete