53
MultiThreadedCalculation Object
The MultithreadedCalculationobject exposes the properties that allow for programmatic control of
the multithreaded calculations (calculations that can be performed across multiple threads).
MultiThreadedCalculation Common Properties
The Application, Creator, and Parentproperties are defined at the beginning of this appendix.
MultiThreadedCalculation Properties
Name
Returns
Description
Enabled
Boolean
Set/Get whether MultiThreadedCalculationobjects
are enabled at run time
ThreatCount
Long
Returns the total count of the process threads that are a
part of the specified MultiThreadedCalculation
object
ThreadMode
XlThreadMode
Set/Get the thread mode for the specified Multi-
ThreadedCalculationobject using an XlThreadMode
constant
Name Object and the Names Collection
The Namescollection holds the list of named ranges in a workbook. Each Nameobject describes a range
of cells in a workbook that can be accessed by the name. Some Nameobjects are built-in (for example,
Print_Area) and others are user-defined. The parent of the Namescollection can be the WorkBook,
Application, or Worksheetobject. The Nameobject can also be accessed through the Rangeobject.
The Namescollection has an Addmethod besides the typical collection attributes. The Addmethod adds a
Nameobject to the collection. The parameters of the Addmethod correspond to the properties of the Name
object.
Name Common Properties
The Application, Creator, and Parentproperties are defined at the beginning of this appendix.
Name Properties
Name
Returns
Description
Category
String
Set/Get the category of the Namein the language used to
create the macro. Valid only if the Nameis a custom func-
tion or command
CategoryLocal
String
Set/Get the category of the Namein the language of the
end user. Valid only if the Nameis a custom function or
command
Comment
String
Set/Get any comments associated with a name
Table continued on following page
783
MultiThreadedCalculation Object
