View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Bundy John Bundy is offline
external usenet poster
 
Posts: 772
Default 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?