The Spreadsheet Guru Blog Deleting Rows With VBA By Looping (Correctly)

If you are using a For Each loop in your VBA macro to delete cell rows, you will likely run into issues of not all desired rows getting deleted. Learn how to properly loop through a range of cells and delete all rows that meet specified criteria.