Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Insert Method

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

Community Additions

© 2015 Microsoft