Represents a named reference defined in the workbook. Syntax Remarks Named references allow for names to be used in formulas instead of complex formulas or cell references. For example, instead of using the formula =SUM(E1:E20), a named reference with a name of Sales can be defined to point to the range of E1:E20 ...
Abstract base class for a named reference defined in the workbook. Syntax
Public Properties
Public Properties
Gets or sets the comment associated with the named reference or table. Syntax Property Value The comment associated with the named reference or table. Exceptions Exception Description System.ArgumentException The value assigned is greater than 255 characters in length.
Gets or sets the name of the reference. Syntax Property Value The name of the reference. Exceptions Exception Description System.ArgumentNullException The value assigned is null or empty. System.ArgumentException The value assigned is longer than 255 characters. System.ArgumentException The value assigned is not a...
Gets the scope of the named reference. Syntax Property Value The scope of the named reference. Remarks This can either be the workbook which the named reference belongs to or one of the worksheets in the workbook. The scope determines how formulas need to preface a name in order to use the named reference. If the ...
A collection of NamedReference instances in a workbook. Syntax
Public Properties Public Methods
Public Methods