Hi All,

I'm trying to find a away to turn off calculation in Excel.

I know how to stop recalculation (Tools Options Calculations)
etc, but I want to be able to type in a formula, or rather have a macro
create many formulas, and not have the formula(s) calculate until I
choose.

Any ideas?


--
jestersdead
------------------------------------------------------------------------
jestersdead's Profile: http://www.excelforum.com/member.php...o&userid=24826
View this thread: http://www.excelforum.com/showthread...hreadid=383794

If you want code, use

Application.Calculation = xlCalculationManual

and at the end use

Application.Calculation = xlCalculationAutomatic

--
HTH

Bob Phillips

"jestersdead"
wrote in message
...

Hi All,

I'm trying to find a away to turn off calculation in Excel.

I know how to stop recalculation (Tools Options Calculations)
etc, but I want to be able to type in a formula, or rather have a macro
create many formulas, and not have the formula(s) calculate until I
choose.

Any ideas?


--
jestersdead
------------------------------------------------------------------------
jestersdead's Profile:
http://www.excelforum.com/member.php...o&userid=24826
View this thread: http://www.excelforum.com/showthread...hreadid=383794

Excel always evaluates each formula as it is entered, even in manual
calculation mode, except when you drag-copy a formula from a cell to a
number of other cells.
The only other alternative is to enter the formula as a string with
something like # instead of = on the front, and then do a search/replace of
# with = when you want the formulae calculated.

Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

"jestersdead"
wrote in message
...

Hi All,

I'm trying to find a away to turn off calculation in Excel.

I know how to stop recalculation (Tools Options Calculations)
etc, but I want to be able to type in a formula, or rather have a macro
create many formulas, and not have the formula(s) calculate until I
choose.

Any ideas?


--
jestersdead
------------------------------------------------------------------------
jestersdead's Profile:
http://www.excelforum.com/member.php...o&userid=24826
View this thread: http://www.excelforum.com/showthread...hreadid=383794

Thanks Charles, I thought I might have to do that, was hoping there was
a more elegant way though.


--
jestersdead
------------------------------------------------------------------------
jestersdead's Profile: http://www.excelforum.com/member.php...o&userid=24826
View this thread: http://www.excelforum.com/showthread...hreadid=383794