Name |
The name of the range.
|
SheetIndex |
The Sheet index where the row and col properties apply. 1-based. When RangeFormula is set, it is not used.
|
NameSheetIndex |
The sheet index for the name (1 based). A named range can have the same name than other as long as they are on different sheets. The default value(0) means a global named range, not tied to any specific sheet.
|
OptionFlags |
Options of the range. You can access the options by using the corresponding properties. (Hidden, BuiltIn, etc).
You can use this property to set them all at the same time.
You can get the properties by OR'ing the following values:
01. Name is hidden. Corresponds to the property Hidden.
02. Name is a function. Corresponds to the property FunctionDef.
04. Name is a VB procedure. If set you also need to set 08 (name is a macro). Corresponds to the property...[more] |
Top |
Top of the range.
|
Left |
Left of the range.
|
Bottom |
Bottom of the range.
|
Right |
Right of the range.
|
RangeFormula |
This is a formula defining the range. It can be used to define complex ranges. For example you can use "=Sheet1!$A:$B,Sheet1!$1:$2". When this parameter is set, SheetIndex, Left, Top, Right and Bottom properties have no meaning.
Note that with relative references, we always consider "A1" to be the cell where the name is. This means that the formula: "=$A$1 + A1" when evaluated in Cell B8, will read "=$A$1 + B8". To provide a negative offset, you need to wrap the formula. For example "=A1048575" will evaluate to B7 when evaluated in B8.
|
Comment |
Returns the comment associated with the name, if there is one. Comments are only available in Excel 2007, but they are saved too in xls file format.
|