Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MACRO Speed?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MACRO Speed?
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 he http://www.decisionmodels.com/ John Jim wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MACRO Speed?
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 he http://www.decisionmodels.com/ John Jim wrote: 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable calculations to speed up Macro | Excel Discussion (Misc queries) | |||
Speed up macro | Excel Discussion (Misc queries) | |||
Range Name affecting speed of macro | Excel Worksheet Functions | |||
Help, need to speed up this macro | Excel Discussion (Misc queries) | |||
Speed up macro | Excel Discussion (Misc queries) |