Thread: Recalc Time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Recalc Time

Hi All...........
Could anyone please tell me that when I send a formula to a cell of an
ActiveSheet with VBA and Excel does a "Recalc", is it only Recalculating that
one sheet or every sheet in the workbook?......If it does them all, how might
I be able to turn off the Recalc at the beginning of my macro for "all
sheets" and then only turn it on for the ONE SHEET I want to recalculate with
each segment of the macro and then turn the whole thing back on when the
macro finishes?

TIA
Vaya con Dios,
Chuck, CABGx3