Insert Method Example

This example inserts a new row before row four on Sheet1.

Worksheets("Sheet1").Rows(4).Insert

This example inserts new cells at the range A1:C5 on Sheet1 and shifts cells downward.

Worksheets("Sheet1").Range("A1:C5").Insert Shift:=xlShiftDown

This example inserts a new row at the active cell. The example must be run from a worksheet.

ActiveCell.EntireRow.Insert