Thread: Command for calculate except datatables
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
isabelle isabelle is offline
external usenet poster
  
Posts: 587
Default Command for calculate except datatables
hi,

Application.Calculation = xlSemiautomatic

Application.Calculation = xlAutomatic

http://msdn.microsoft.com/en-us/libr... ice.14).aspx

xlCalculationAutomatic Excel controls recalculation.
xlCalculationManual Calculation is done when the user requests it.
xlCalculationSemiautomatic Excel controls recalculation but ignores changes in
tables.

isabelle

Le 2014-04-14 15:27, a écrit :
Is there a command for this? Does switching to semiautomatic and then back to manual force a calculation?

Many thanks
Gary

Reply With QuoteReply With Quote