Range.Insert Method (Excel)
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