View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default How to force all of the cells in a worksheet to recalculate?

are you turning calculation off with the macro or is it set to manual?

this will set it to automatic, add it to the end of your code and see if it
helps

application.Calculation = xlautomatic

--


Gary


"LurfysMa" wrote in message
...
I have a worksheet that calls some custom macros.

When I change the macro, the cells don't recalculate.

How can I tell Excel to recalculate all of the cells in the worksheet?

--