1) You could copy and paste without the clipboard by using one line
mysourcerange.copy mydestinationrange

or 2) you could empty the clipboard after each use
Application.CutCopyMode = False

Additionally have you turned off screenupdating and auto calculation?

"Jai" wrote:

Hello All,

I am working on an Excel project wherein a number of workbooks (upto 25
) are created every month and populated from a Master List - with say 500
rows each. I am running into serious memory issues. It would help to know how
Excel alocates and uses memory and frees it up once complete.

Im my particular application, I do a lot of block copy and paste -
possibly using the clip board (I use the copy and paste methods in VBA). How
do I release this memory when done.

Is there some guidance on good VBA programming for efficient memory
utilisation?

Jai