Range("B5:B200").SpecialCells(xlCellTypeBlanks).En tireRow.Delete



" wrote:

Could some pls help me with the below macro.

Starting from row 5 to say 200

I want to delete the entire row if a cell in Col B is blank/empty.

Thanks