Disable calculations to speed up Macro

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
 
M

muddan madhu

Application.calculation = xlcalculationmanual

your code

Application.calculation = xlcalculationautomatic
 
B

Bob Phillips

Application.Calculation = xlCalculationManual

....your code

Application.Calculation = xlCalculationAutomatic
 
Top