Creates an
XLNamedRange object and appends it to the collection.
'Declaration
Public Overloads Function Add( _
ByVal As System.String, _
ByVal As XLSheet, _
ByVal As System.Integer, _
ByVal As System.Integer, _
ByVal As System.Integer, _
ByVal As System.Integer _
) As XLNamedRange
'Usage
Dim instance As XLNamedRangeCollection
Dim name As System.String
Dim sheet As XLSheet
Dim rowIndex As System.Integer
Dim colIndex As System.Integer
Dim rowCount As System.Integer
Dim colCount As System.Integer
Dim value As XLNamedRange
value = instance.Add(name, sheet, rowIndex, colIndex, rowCount, colCount)
public XLNamedRange Add(
System.string ,
XLSheet ,
System.int ,
System.int ,
System.int ,
System.int
)
Parameters
- name
- The name of XLNamedRange object.
- sheet
- The worksheet containing the range.
- rowIndex
- The index of the top row in the cell range.
- colIndex
- The index of the left column in the cell range.
- rowCount
- The number of rows in the cell range.
- colCount
- The number of columns in the cell range.
Return Value
A reference to the object if it was successfully added to the collection, or null if the object could not be added (usually because it overlaps another cell range already in the collection).