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

If using Excel 97 and running the code from a commandbutton, try changing
the TakeFocusOnClick property of the commandbutton to false.

--
Regards,
Tom Ogilvy

"Simon P" wrote in message
...
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