Calculation Stopped

  • Thread starter Thread starter jc
  • Start date Start date
J

jc

I have a macro which has been working for quite some
time. I made some changes in the workbook (not the macro)
and lately when I run the macro the Calculate sheet
command doesn't work. If I use F9 and calculate the
entire workbook after the macro is done, that works, but I
really want the macro to just calculate the one worksheet
I updated. Calculating the entire workbook takes a lot
longer than just the worksheet. Anyone have any ideas why
calculate sheet in my macro would stop working?
 
Have you looked in tools, options, calculations and made sure th
Automatic is checked? you could also add this line to your code if yo
like:-

With Application
.Calculation = xlCalculationAutomatic
End With

Hope this helps


Simo
 

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

Force Calculation 5
Worksheet calculate -question 1
Stop Command Question 4
Macro independant of workbook 2
Accuracy of Using Calculate - IMPORTANT QUESTION PLEASE 2
Macro that unhides a sheet and takes the user to that sheet 2
stopping a range from calculating 5
Can a test to determine whether a workbook needs to be calculated beperformed? 3

Back
Top