View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kh[_2_] kh[_2_] is offline
external usenet poster
 
Posts: 3
Default Calculation mode and recalcs

Hi. In VBA, if the current Application.Calculation mode is set to
xlCalculationManual, does setting it to xlCalculationAutomatic force a recalc
of any pending changes to the workbook or do I need to explicitly call
Application.Calculate() ?

Many thanks

kh