Command for calculate except datatables

[gazpage]

Is there a command for this? Does switching to semiautomatic and then back to manual force a calculation?

Many thanks
Gary

 

[isabelle]

hi,

Application.Calculation = xlSemiautomatic

Application.Calculation = xlAutomatic

http://msdn.microsoft.com/en-us/lib...interop.excel.xlcalculation(v=office.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, (e-mail address removed) a écrit :