View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew Andrew is offline
external usenet poster
 
Posts: 358
Default macros run increasingly slowly

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?