Hi,

I have a macro which creates a fair number of sheets and charts --
during execution sometimes it produces an error when attempting to paste some chart. I assume this is due to memory contrains since it does not happen always and the problem solves itself when I restart excel.

is there any way to free up memory or clear whatever it is that is bugging this process?

buying a better computer would do the trick I guess -- but not an option unforunately.

thanks!