Tip sumited by Dave Ramage, UK
A tip to quickly and efficiently delete all rows that contain a blank cell in a certain column.
First select the single column range that you want to check, then execute this line of code:
Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete