Here Row Numbers are your row numbers to delete. And EntireRow.Delete method will delete the Entire rows from the Excel spreadsheet.
Delete multiple rows using VBA: Examples
The following VBA code is to delete multiple rows from the worksheet. This code will delete the multiple rows (1 to 3) which we have mentioned in the code.
Sub sbVBS_To_Delete_Multiple_Rows ()
Instructions to run the VBA code to delete multiple rows
Please follow the below steps to execute the VBA code to delete multiple rows from worksheets.
Step 1: Open any existing Excel workbook
Step 2: Press Alt+F11 – This will open the VBA Editor
Step 3: Insert a code module from then insert menu
Step 4: Copy the above code and paste in the code module which have inserted in the above step
Step 5: enter some sample data in row 1 to 5
Step 6: Now press F5 to execute the code
Now you can observe that the entire rows from 1 to 3 are deleted from worksheet.
Explained VBA Code to Delete Multiple Rows:
‘Starting program and sub procedure to write VBA code to delete entire row from sheet
‘Specifying the Rows to delete and Deleting the Rows using EntireRow.Delete method.
‘Ending the sub procedure to delete entire row
Here Rows(“1:3”) is to tell excel to delete rows from 1 to 3 of the worksheet. And Delete method will delete the all specified rows form the worksheet.