Disable calculations to speed up Macro

  • Thread starter Thread starter leerem
  • Start date Start date
L

leerem

I have a fairly large spreadsheet, that takes a long time to run due to the
number of times it re-calculates.
Is there any way i can using code, disable the calculation at the start of
the routine and then re-enable at the end?

Regards
Lee
 
Application.calculation = xlcalculationmanual

your code

Application.calculation = xlcalculationautomatic
 
Application.Calculation = xlCalculationManual

....your code

Application.Calculation = xlCalculationAutomatic
 
Back
Top