Calculation Enable

[raj08536]

Following is the wrong syntex

Worksheets("HighlevelFcstSite").Range("A253:IV2000").EnableCalculation = False

Can a Guru help me to correct this one?

 

[MrKowz]

You can't disable calculations for a specific range, but you can for the entire application:

Application.Calculation = xlCalculationManual

 

[raj08536]

Thanks for your prompt response.

However, following is working perfectly fine at worksheet level but range level is not working.


Worksheets("HighlevelFcstSite").EnableCalculation = True

 

[shg]

Or a whole worksheet:

Worksheets("HighlevelFcstSite").<S>Range("A253:IV2000").</S>EnableCalculation = False

EDIT: See Applies To in Help for the EnableCalculation property.