Application.Calculation

[Cyberdude]

The Excel environment property "Calculation" can have 3 settings: xlAutomatic (default), xlManual, and xlSemiAutomatic. What are the characteristics of "xlSemiAutomatic"? Until today I had never seen that option. When would one use it?
And if you know the answer, how in the world did you find it? I have had difficulty at times finding descriptions of some of these constants. :bug:

[mvidas]

Hi CD,

The xlCalculationSemiAutomatic constant refers to the "Automatic except tables" option in Tools / Options / Calculate tab.

See this for more info: http://www.ozgrid.com/forum/showthread.php?t=24178

Matt

[Cyberdude]

Thanx, Matt. Good reference! I appreciate it.
Sid :friends: