For example, if I want to delete first 5 rows.
Range("A1:A5").EntireRow.Delete should work fine.
However, I would like to know if there is alternative way to do it. I would like to write something as below, but syntax is wrong, how to fix it? The code Rows looks more meaningful to me.
Rows(1:5).EntireRow.Delete
Rows(1).EntireRow.Delete works fine when deleting first row only.
Bookmarks