Initial Formula Calculation

[jestersdead]

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 macr
create many formulas, and not have the formula(s) calculate until
choose.

Any ideas

 

[Bob Phillips]

If you want code, use

Application.Calculation = xlCalculationManual

and at the end use

Application.Calculation = xlCalculationAutomatic

--
HTH

Bob Phillips

"jestersdead" <[email protected]>
wrote in message
news:[email protected]...

 

[Charles Williams]

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" <[email protected]>
wrote in message
news:[email protected]...

 

[jestersdead]

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