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.

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

Show: