Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command for calculate except datatables
Is there a command for this? Does switching to semiautomatic and then back to manual force a calculation?
Many thanks Gary |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selective calculate command button & other questions. | Excel Discussion (Misc queries) | |||
Export multiple datatables from a C# form to Multiple Excel sheets | Excel Programming | |||
Calculate command | Excel Programming | |||
command button to calculate two cell values? | Excel Programming | |||
Use of the DSUM formula to find exact matches in datatables | Excel Worksheet Functions |