Run Time error '1004' when running Calculation method

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
I am getting a Run Time error '1004' when running Calulation method lines
Click to expand...
in my code. I'm running the code for speed reasons along side
Application.ScreenUpdating = False which has improved the speed of my app.
 
Back
Top