Inserts a cell or a range of cells into the worksheet or macro sheet and shifts other cells away to make space.
expression . Insert( Shift , CopyOrigin )
expression A variable that represents a Range object.
| 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. |
Variant