Calculation on/off in excel
 

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?

Calculation on/off in excel
 

Something like
Range("A1:C10").Calculate
will do it
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"James C." wrote:

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?

Calculation on/off in excel
 

Simple and easy....thanks

"John Bundy" wrote:

Something like
Range("A1:C10").Calculate
will do it
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"James C." wrote:

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?