VBA: How to clear a row with an empty cell in one of its columns, without deleting entire row?
===

A seemingly simple issue:

I have data in Columns A:E. Column E has some blank cells in some of the rows.

I would like to remove ALL THE ROW that include a blank cell in E. **However, Here's the catch**, there is other data in subsequent columns. if I delete the entire row, this data will be also deleted, which I don't want.

To be more specific, I need to:
(1) Check column E for blank cells
(2) When a blank cell if found, clear the row that has this cell, but only Columns A:E
(3) Shift the data in Columns A:E up

I tried:

    Range("E2:E100").SpecialCells(xlCellTypeBlanks).Delete Shift:=xlUp

But this one only shifts data in column E, not the entire row.

of course, i can use:

    Range("E2:E100").SpecialCells(xlCellTypeBlanks).EntireRow.Delete

But like I said, this will delete data in subsequent columns, which I don't want.

Any tips?

Thanks,

Al

