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