Is there a reason why manual calculation isn't switched back to automatic at the end of my sheet_change event code?

[Ironman]

Some of the code isn't running in one of my sheets but it's only because the calculation method keeps changing to manual - as soon as I change it back for the umpteenth time then it runs fine.

I looked at the sheet change event code and at the start it says Application.Calculation = xlCalculationManual so I'm wondering why it wouldn't change to Application.Calculation = xlCalculationAutomatic at the end?

Is this likely to be just an omission or would there any disadvantage in me inserting "Application.Calculation = xlCalculationAutomatic" at the end of the change event?

Thanks!

 

[Joe4]

It sounds to me like an omission and you should just add a line to add it back in at the end of your code.

 

[Ironman]

Thanks Joe!

 

[Joe4]

You are welcome.