Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / IRange Interface / Insert Method
A InsertShiftDirection value indicates which way to shift the cells. If this argument is omitted, Spread decides based on the shape of the range.
A InsertFormatOrigin value indicates where to copy the format for inserted cells.


In This Topic
    Insert Method (IRange)
    In This Topic
    Inserts a cell or a range of cells into the worksheet and shifts other cells away to make space.
    Syntax
    'Declaration
     
    
    Sub Insert( _
       Optional ByVal shift As InsertShiftDirection, _
       Optional ByVal origin As InsertFormatOrigin _
    ) 
    'Usage
     
    
    Dim instance As IRange
    Dim shift As InsertShiftDirection
    Dim origin As InsertFormatOrigin
     
    instance.Insert(shift, origin)

    Parameters

    shift
    A InsertShiftDirection value indicates which way to shift the cells. If this argument is omitted, Spread decides based on the shape of the range.
    origin
    A InsertFormatOrigin value indicates where to copy the format for inserted cells.
    See Also