Excel for WPF | ComponentOne
C1.Silverlight.Excel Namespace / XLNamedRangeCollection Class / Add Method / Add(String,Int32,Int32,Int32,Int32) Method
The name of XLNamedRange object.
The index of the first XLSheet to include.
The index of the last XLSheet to include.
The index of the top row in the cell range.
The index of the left column in the cell range.

In This Topic
    Add(String,Int32,Int32,Int32,Int32) Method
    In This Topic
    Creates an XLNamedRange object and appends it to the collection. This overload allows you to create a 3-D reference to the same range of cells on multiple worksheets.
    Syntax
    'Declaration
     
    
    Public Overloads Function Add( _
       ByVal name As String, _
       ByVal firstSheetIndex As Integer, _
       ByVal lastSheetIndex As Integer, _
       ByVal rowIndex As Integer, _
       ByVal colIndex As Integer _
    ) As XLNamedRange

    Parameters

    name
    The name of XLNamedRange object.
    firstSheetIndex
    The index of the first XLSheet to include.
    lastSheetIndex
    The index of the last XLSheet to include.
    rowIndex
    The index of the top row in the cell range.
    colIndex
    The index of the left column 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).
    See Also