I am getting a Run Time error '1004' when running Calulation method lines in my code. I'm running the code for speed reasons along side Application.ScreenUpdating = False which has improved the speed of my app.

The lines which trigger the error are :

Application.Calculation = xlCalculationAutomatic or
Application.Calculation = xlCalculationManual

Any suggestions / help much appreciated.

Simon