Range.Insert Method
Inserts a cell or a range of cells into the worksheet or macro sheet and shifts other cells away to make space.
Syntax
expression.Insert(Shift, CopyOrigin)
expression A variable that represents a Range object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Shift | Optional | Variant | Specifies which way to shift the cells. Can be one of the following XlInsertShiftDirection constants: xlShiftToRight or xlShiftDown. If this argument is omitted, Microsoft Excel decides based on the shape of the range. |
| CopyOrigin | Optional | Variant | The copy origin. |
Return Value
Variant