I have a sub routine that runs really slowly unless the calculation method is set to manual. I can run the sub from the VB window OK (the sub is in Module 1) but if I try to run it from a button on a worksheet I get a "Method 'calculation' of object 'application' failed" error message.
The line of code I'm using is:
Application.Calculation = xlCalculationManual
This is really driving me mad. Can anyone help?
JohnnyC
The line of code I'm using is:
Application.Calculation = xlCalculationManual
This is really driving me mad. Can anyone help?
JohnnyC