This documentation is archived and is not being maintained.

Range.Insert Method

Office 2007
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.


NameRequired/OptionalData TypeDescription
ShiftOptionalVariantSpecifies 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.
CopyOriginOptionalVariantThe copy origin.

Return Value