Static $tStatic nextGets the number of named references in the collection. The number of named references in the collection.
Adds a named reference with a scope of the collection's associated workbook to the collection.
The CellReferenceMode of the owning workbook will be used to parse the formula.
ArgumentNullException 'name' is null or empty.
ArgumentException 'name' is longer than 255 characters.
ArgumentException 'name' is invalid. The name must begin with a letter, underscore (), or a backslash (). All other characters in the name must be letters, numbers, periods, underscores (), or backslashes (). The name cannot be a an A1 cell reference (1 to 3 letters followed by 1 to 6 numbers). In addition, the name cannot be 'r', 'R', 'c', or 'C' or start with a row or column reference in R1C1 cell reference mode ('R' followed by 1 to 6 numbers or 'C' followed by 1 to 6 numbers).
InvalidOperationException 'name' is used by another named reference which also has a scope of the workbook. Named reference names are compared case-insensitively.
ArgumentNullException 'formula' is null or empty.
ArgumentException 'formula' is not a valid formula. The inner exception will contain the FormulaParseException describing the reason the formula was not valid.
The named reference which was added to the collection.
The name to give the named reference.
The formula to give the named reference.
Adds a named reference with a scope of the collection's associated workbook to the collection.
ArgumentNullException 'name' is null or empty.
ArgumentException 'name' is longer than 255 characters.
ArgumentException 'name' is invalid. The name must begin with a letter, underscore (), or a backslash (). All other characters in the name must be letters, numbers, periods, underscores (), or backslashes (). The name cannot be a an A1 cell reference (1 to 3 letters followed by 1 to 6 numbers). In addition, the name cannot be 'r', 'R', 'c', or 'C' or start with a row or column reference in R1C1 cell reference mode ('R' followed by 1 to 6 numbers or 'C' followed by 1 to 6 numbers).
InvalidOperationException 'name' is used by another named reference which also has a scope of the workbook. Named reference names are compared case-insensitively.
ArgumentNullException 'formula' is null or empty.
ArgumentException 'formula' is not a valid formula. The inner exception will contain the FormulaParseException describing the reason the formula was not valid.
InvalidEnumArgumentException 'cellReferenceMode' is not defined in the CellReferenceMode enumeration.
The named reference which was added to the collection.
The name to give the named reference.
The formula to give the named reference.
The mode used to interpret cell references in the formula.
Adds a named reference with a scope of a worksheet to the collection.
ArgumentNullException 'name' is null or empty.
ArgumentException 'name' is longer than 255 characters.
ArgumentException 'name' is invalid. The name must begin with a letter, underscore (), or a backslash (). All other characters in the name must be letters, numbers, periods, underscores (), or backslashes (). The name cannot be a an A1 cell reference (1 to 3 letters followed by 1 to 6 numbers). In addition, the name cannot be 'r', 'R', 'c', or 'C' or start with a row or column reference in R1C1 cell reference mode ('R' followed by 1 to 6 numbers or 'C' followed by 1 to 6 numbers).
InvalidOperationException 'name' is used by another named reference which also has a scope of the specified 'worksheet'. Named reference names are compared case-insensitively.
ArgumentNullException 'formula' is null or empty.
ArgumentException 'formula' is not a valid formula. The inner exception will contain the FormulaParseException describing the reason the formula was not valid.
InvalidEnumArgumentException 'cellReferenceMode' is not defined in the CellReferenceMode enumeration.
ArgumentNullException 'worksheet' is null.
ArgumentException 'worksheet' does not belong to the workbook owning this collection.
The named reference which was added to the collection.
The name to give the named reference.
The formula to give the named reference.
The mode used to interpret cell references in the formula.
The scope of the named reference.
Adds a named reference with a scope of a worksheet to the collection.
The CellReferenceMode of the owning workbook will be used to parse the formula.
ArgumentNullException 'name' is null or empty.
ArgumentException 'name' is longer than 255 characters.
ArgumentException 'name' is invalid. The name must begin with a letter, underscore (), or a backslash (). All other characters in the name must be letters, numbers, periods, underscores (), or backslashes (). The name cannot be a an A1 cell reference (1 to 3 letters followed by 1 to 6 numbers). In addition, the name cannot be 'r', 'R', 'c', or 'C' or start with a row or column reference in R1C1 cell reference mode ('R' followed by 1 to 6 numbers or 'C' followed by 1 to 6 numbers).
InvalidOperationException 'name' is used by another named reference which also has a scope of the specified 'worksheet'. Named reference names are compared case-insensitively.
ArgumentNullException 'formula' is null or empty.
ArgumentException 'formula' is not a valid formula. The inner exception will contain the FormulaParseException describing the reason the formula was not valid.
ArgumentNullException 'worksheet' is null.
ArgumentException 'worksheet' does not belong to the workbook owning this collection.
The named reference which was added to the collection.
The name to give the named reference.
The formula to give the named reference.
The scope of the named reference.
Determines whether a named reference is in the collection.
True if the named reference is found; False otherwise.
The named reference to locate in the collection.
Finds a named reference in the collection with a scope of the collection's associated Workbook.
Named reference names are compared case-insensitively.
ArgumentNullException 'name' is null or empty.
The named reference with the specified name or null if the named reference was not found.
The name of the named reference to find.
Finds a named reference in the collection with a scope of the specified worksheet.
Named reference names are compared case-insensitively.
ArgumentNullException 'name' is null or empty.
ArgumentNullException 'worksheetScope' is null.
The named reference with the specified name or null if the named reference was not found.
The name of the named reference to find.
The worksheet that the named reference found must have a scope of.
Finds all named references in the collection with the specified name.
Named reference names are compared case-insensitively.
ArgumentNullException 'name' is null or empty.
An array of NamedReference instances with the specified name.
The name of the named references to find.
Gets the named reference at the specified index. The named reference at the specified index.
ArgumentOutOfRangeException 'index' is less than zero or 'index' is greater than or equal to count.
Removes the named reference at the specified index in the collection.
ArgumentOutOfRangeException 'index' is less than zero or 'index' is greater than or equal to count.
The zero-based index of the named reference in the collection.
Removes the specified named reference from the collection.
True if the named reference existed in the collection and was removed; False otherwise.
The named reference to remove fro the collection.
Static compareStatic compareStatic equalsStatic equalsStatic getStatic getStatic getStatic referenceStatic static
A collection of NamedReference instances in a workbook.
See