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