MACRO Speed?

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I have a pretty complex Macro that compiles and sorts 5
Worksheets of data containing a combined 1300 names. It
has worked fine and fast until now. I added a replace
function to it and now it takes forever. What can be
done to increase the speed of the Macro? Please help.
 
Thanks John!
-----Original Message-----
Jim,

Coupla' options.....
Turn off ScreenUpdating while the macro runs:
Application.ScreenUpdating = False
(set it back to True at the end of your macro)
Turn off Calculation also:
Application.Calculation = xlCalculationManual
(set it back to Automatic at the end of your macro)

Take a look here for more info on speeding things up:
http://www.mvps.org/dmcritchie/excel/slowresp.htm

and also here:
http://www.decisionmodels.com/

John


.
Click to expand...
 
Back
Top