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

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=27549