Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selective calculate command button & other questions. DangerPayne Excel Discussion (Misc queries) 1 December 23rd 08 08:45 AM
Export multiple datatables from a C# form to Multiple Excel sheets TRBG Excel Programming 1 May 2nd 08 06:24 AM
Calculate command W Wolfe Excel Programming 2 April 24th 08 03:41 PM
command button to calculate two cell values? sunil5 Excel Programming 3 June 27th 05 03:34 PM
Use of the DSUM formula to find exact matches in datatables Rob Henson Excel Worksheet Functions 1 January 27th 05 03:14 AM


All times are GMT +1. The time now is 01:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"