Share via

Insert Method

  • Article

Inserts a cell or a range of cells into the worksheet and shifts other cells away to make space.

expression.Insert(Shift)

*expression   * Required. An expression that returns a Range object.

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.

Applies to | Range Object

See Also | Delete Method