Thanks for the info Bob. I tried that as well. I thought it worked -
the 1st run was 6 seconds...but then the second was 7 minutes...but
then strangely enough the 3rd run was only 6 seconds again!!

I just don't get it!!

Anybody else have any ideas? Could it possibly be the Consolidate
function that is clogging up memory or something?!

Hi Steph,
Please stick to one thread. There is no way someone looking
in the archives is going to connect these two threads, so you
leave an unresolved thread, and start a new thread without
material that appeared earlier.

Check your last cell indication Ctrl+End

If that is a problem put this line of code near the beginning
of your macro. [http://www.mvps.org/dmcritchie/excel/lastcell.htm]

Dim x As Long 'Attempt to fix the lastcell on the current worksheet
x = ActiveWorksheet.UsedRange.Rows.Count 'see J-Walkenbach tip 73

Most things that I can think of are cumulative, they just get worse.

Check your task manager Ctrl+Alt+Del [Task Manager]
while running. Switch to the Performance tab
View, Show kernel times (adds red line in CPU Usage History)
As I understand it if the red line is close to the green CPU usage
line then you are swapped out a lot.
Tuning with Additional Windows NT Utilities, James Stewart
http://www.windowsitlibrary.com/Content/113/05/1.html
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Steph" wrote ...
Thanks for the info Bob. I tried that as well. I thought it worked -
the 1st run was 6 seconds...but then the second was 7 minutes...but
then strangely enough the 3rd run was only 6 seconds again!!

I just don't get it!!

Anybody else have any ideas? Could it possibly be the Consolidate
function that is clogging up memory or something?!