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