Calculation Stopped

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?
 
S

Simon Lloyd

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

Top