Possible to set part of a sheet to manual calculation mode?

[auto.pilot]

Using XL07, one of my macros is running slowly, and I'm wondinger if it's possible to set a certain range on this sheet to manual calculation mode. For example, if cell C5 = "NA", then all calculations in row 5 should be ignored.

I have also considered using code which would copy, then paste special values, basically over-writing all of the folumlas in a row when "NA" is found in column C.

Would appreciate any thoughts/advice.


Thanks in advance.

 

[Tuelor]

I don't think you can. I would do the following; set calculation to manual, and call calculate when needed in the code.


Dim sCalc as String
sCalc = Application.Calculation
Application.Calculation = xlCalculationManual

.
.
.

Range(A:A).Calculate

.
.
.

Application.Calculation = sCalc