View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jc jc is offline
external usenet poster
 
Posts: 18
Default Calculation Stopped

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?