Calculation on/off in excel

's Computer Specifications

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?

's Computer Specifications

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?

's Computer Specifications

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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Interrupting long calculations in Excel? Hi all, I am having a verylong calculation in Excel using VBA. Of course I know I can hit ESC orCTRL+BREAK to interrupt the VBA program. But I found due to too long runningprocess, the Excel window stop to	LunaMoon	Microsoft Excel Discussion	3	31st Jul 2008 04:47 PM
Interrupting long calculations in Excel? Hi all, I am having a verylong calculation in Excel using VBA. Of course I know I can hit ESC orCTRL+BREAK to interrupt the VBA program. But I found due to too long runningprocess, the Excel window stop to	LunaMoon	Microsoft Excel Programming	3	31st Jul 2008 04:47 PM
Interrupting long calculations in Excel? Hi all, I am having a verylong calculation in Excel using VBA. Of course I know I can hit ESC orCTRL+BREAK to interrupt the VBA program. But I found due to too long runningprocess, the Excel window stop to	LunaMoon	Microsoft Excel Misc	3	31st Jul 2008 04:47 PM
Excel Automatic Calculation makes Excel the Active Application	Clementius	Microsoft Excel Discussion	1	4th May 2007 08:17 AM
Excel 2003 versus Excel 2007 calculation speed	Stan Brown	Microsoft Excel Discussion	7	10th Apr 2007 07:07 PM