Calculation on/off in excel

[James C.]

currenty I have the auto calculations function turned off in excel. Using
code I turn it on when I need to calculate something. The problem is, it
recalculates everything and takes a long time. Is it possible to Only auto
calculate a specific cell range?

 

[John Bundy]

Something like
Range("A1:C10").Calculate
will do it

 

[James C.]

Simple and easy....thanks

Something like
Range("A1:C10").Calculate
will do it