macros and screen updates
Tim Laud wrote:
I've written a macro that updates several sheets and
graphs. Execution is very slow because of the constant
refreshing of the display.
Is there a way to turn off the screen updates until the
macros have finished?
Application.ScreenUpdating = False
Calculations can also slow down your macros. You might want to add
Application.Calculation = xlCalculationManual to the start of your macro
and Application.Calculation = xlCalculationAutomatic to the end.
|