xlCalculateManual causes error 1

[glenntb]

Greetings! I have a large spreadsheet with many formulas. During macro processing, I would like to turn the calculation to manual instead of automatic. From the help files, I found:

Application.Calculation = xlCalculateManual
Application.CalculateBeforeSave = True

but when I run it, it throws an error:
Method 'Calcluation' of object '_Application' failed

When I added Msgbox xlCalculateManual to the code, it shows that xlCalculateManual is empty.

Any idea what I'm missing? Thanks in advance!

 

[rmikesmith]

Glenn,

My copy of Excel shows the constant to be xlCalculationManual, not xlCalculateManual.


HTH
Mike

 

[glenntb]

Works like a charm! It must be a typo in the help files.

Thanks Mike!