How to delete multiple rows without a loop in Excel VBA

Question

Frequently we are asked how to delete rows based on criteria in one or more columns, and can we use a SpecialCells trick for this?

Answer 1

This will delete row numbers m to n passed through the function

Sub Delete_Multiple_Rows (m as Integer, n as Integer) 

    Rows(m & ":" & n).EntireRow.Delete 

End Sub