Share via


Range.Insert Method

Excel Developer Reference

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

See Also