Thanks for the response JieJenn, however the way that your macro functions is that if only 1 cell is blank but others contain data, that row is still deleted.

I need to be able to only delete the rows that literally have nothing in them.

So for example, I may have a row where columns A, B and C are empty, but D contains needed data; in this case I would not want to delete that row. Does that make sense?