ComponentOne Excel for .NET
C1.Excel Assembly / C1.Excel Namespace / XLNamedRangeCollection Class / Add Method / Add(String,XLSheet,Int32,Int32) Method
The name of XLNamedRange object.
The worksheet the range belongs to.
The row index of the cell in the range.
The column index of the cell in the range.

In This Topic
    Add(String,XLSheet,Int32,Int32) Method
    In This Topic
    Creates an XLNamedRange object and appends it to the collection. This overload creates a range containing a single cell.
    Syntax
    'Declaration
     
    Public Overloads Function Add( _
       ByVal name As System.String, _
       ByVal sheet As XLSheet, _
       ByVal rowIndex As System.Integer, _
       ByVal colIndex As System.Integer _
    ) As XLNamedRange
    public XLNamedRange Add( 
       System.string name,
       XLSheet sheet,
       System.int rowIndex,
       System.int colIndex
    )

    Parameters

    name
    The name of XLNamedRange object.
    sheet
    The worksheet the range belongs to.
    rowIndex
    The row index of the cell in the range.
    colIndex
    The column index of the cell in the 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).
    See Also