Pete,
If 25 minutes is the minimum process time for a WS, as a quick fix, you
could start a new instance of Excel, process the file, close Excel, open
Excel, process...
The added 30 seconds to close/reopen Excel would not add much to 25 minutes
and you would be certain to clear all memory.

NickHK

wrote in message
oups.com...
I wrote a maco that will process 14 different spreadsheets. It will
automaticlly bring in a spreadsheet process it, write it out, and get
the next one to process. These are very big spreadsheets like over
30,000 rows each. The first one takes about 25 mins to process then
the next an hour until after about 5 times its up to 3 to 3 1/2 hours.
Is there a way to clear memory between each loop.
Thanks