Run Time error '1004' when running Calculation method

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
 
T

Tom Ogilvy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run macro on all files in a specific folder 3
Very Slow Worksheet Calculation 4
Run-time error '1004': PasteSpecial method of Range class failed 1
Application Calculation Error 2
"Run-time error '1004' 5
InStr Help - Multiple Criteria 3
Run-time error '1004' at "Application.Calculate" 2
Problem with Hiding Every Other Column - Still need Help 3

Top