DeleteRows Method Example

Deleted rows include the specified range. This example deletes rows 2 and 3 from the active worksheet.

Spreadsheet1.ActiveSheet.Range("b2").DeleteRows 2

This example deletes only row 2.

Spreadsheet1.ActiveSheet.Range("b2:f5").DeleteRows 1

This example deletes rows 3 and 4.

Spreadsheet1.ActiveSheet.Range("b3:f4").DeleteRows