Yeah you just need to switch the automatic calculation off, you can do
this with the following:

Application.Calculation = xlManual

The other option you have is whether to calculate the spreadsheet
before saving it which is:

Application.CalculateBeforeSave = False

But that all depends on what you are trying to do.

Again I think you may need to switch these both back on when your
finished so you can you use:

Application.Calculation = xlAutomatic

Any Problems then give me a shout.

James

(Spammastergrand) wrote in message ...
Is there code to stop calculation from happening with formulas?