Stop update formulas when macro starts then update when complete

[ruperupe]

Hi

I would like to Stop update formulas when macro starts then update when complete to speed up a process. Is this possible?

Thanks Rup

[dilipandey]

Hi Rup,

You can set the formula calculation to Manual before running macro which will not update formula results and you can again set formula calculation to Automatic mode. thank.s

Regards,
DILIPandey

<click on below 'star' if this helps>

[ruperupe]

Thanks dilipandey,

Good Answer,

is there a way to do this in the macro?

Thanks

[dilipandey]

Yes..

you can use following code:-

Sub cal()
    Application.Calculation = xlManual

'you can do your steps here OR you can paste your code here

    Application.Calculation = xlAutomatic
    Calculate
End Sub

Regards,
DILIPandey

<click on below 'star' if this helps>

[Cutter]

You would use

Application.Calculation = xlCalculationManual
your code
Application.Calculation = xlCalculationAutomatic

[ruperupe]

This is great, just saved me waiting time of about ten minutes per scenario,
Good Work guys,
Thanks

[dilipandey]

great..

If you are satisfied with the solution provided here, request you to mark this thread as sovled, seethe forum rules to do so. thanks.

http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey

<click on below 'star' if this helps>

[Cutter]

You should also edit your profile - unless of course there actually IS a London, Englans!