This is a macro which will delete blank rows in excel. This version will delete an entire row if there is a blank cell detected in the column which you select.

This works by having a message box pop up in excel and then asking you how many rows, below and including the cell you selected, you want to check for and delete if it contains an empty cell within that column.

This macro for excel works very well; though, note that you will have to input, in the automated message box, the number of rows down that you want to check for.