xlThreadMode

Specifies the control over the multi-threaded calculation mode.

xlThreadModeAutomaticThis tells Excel to use all the processors on this computer (0)
xlThreadModeManualThis lets you tell Excel how many processors you want to use (1)

xlThreadModeAutomatic
This tells Excel to use all the processors on this computer (0)
xlThreadModeManual
This lets you tell Excel how many processors you want to use (1)

REMARKS
* Added in 2007.
* xlThreadModeManual lets you use the Application.MultiThreadedCalculation.ThreadCount property to set how many you want to use.
* More details can be found on Formulas > Calculation - Multi Threading

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top