[]
Inserts a cell or a range of cells into the worksheet and shifts other cells away to make space.
void Insert(InsertShiftDirection shift = (InsertShiftDirection)-1, InsertFormatOrigin origin = InsertFormatOrigin.LeftOrAbove)
Sub Insert(Optional shift As InsertShiftDirection = -1, Optional origin As InsertFormatOrigin = InsertFormatOrigin.LeftOrAbove)
Type | Name | Description |
---|---|---|
InsertShiftDirection | 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. |
InsertFormatOrigin | origin | A InsertFormatOrigin value indicates where to copy the format for inserted cells. |