We can use the VBA RANGE object to delete more than one row. Example #4ĭelete Multiple Rows by Using Range Object Now use the property “EntireRow” property.Īfter selecting the property, what we need to do i.e., method. Now we need to mention what is the row we need to delete.
Now we will see how to delete by using ROWS property. In the above example, we have deleted the row by using CELLS property.
We can delete the row by using several ways. Now, if I run this code, it will delete the entire row, not a single cell. If you want to delete the entire row, we need to use the property “EntireRow,” then we need to use the method “delete” to delete the entire row of the cell we have selected.įor example, I have entered a few characters in an excel sheet as follows. All the right side values will shift one cell to the left.