Calculation Stopped

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

 

[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