Run Time Issues

[Steph]

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?!

 

[David McRitchie]

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