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)

void Insert( 
   InsertShiftDirection shift,
   InsertFormatOrigin origin
)

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.