Here is a great resource on optimizing speed and memory allocation. If things
start to run slowly often it is a matter of running out of memory. (Excel can
not use all of your memeory. The amount depends on your version.). It may
help

http://www.decisionmodels.com/index.htm
--
HTH...

Jim Thomlinson


"Andrew" wrote:

I am running excel 2002 on Windows XP, i have a fast machine with 1gb memory.
I use a simple macro that removes and reinserts sub-totals, sorts and adds
some formatting.

The first time i run the macro it works quickly. On susbequent occaisions
it slows down almost to the point of stopping (10 minutes or more).

I have not written any fancy code, just recorded the actions. (On weaker
machines with less memory etc. this problem does not materialse).

Can anyone suggest anything?