VBA - deleting rows

[PoliD]

Hello everyone,
Could you please help me with VBA script for deleting an entire row when a cell in range is blank?
I have columns A and B. A with IDs and B with specific text in them. However, some of the cells in both columns are empty, so I want to delete the entire row if a cell in A or B is blank.
Thank you.

 

[rpaulson]

try this on a copy of your file

Range("A:B").SpecialCells(xlCellTypeBlanks).EntireRow.Delete

 

[PoliD]

try this on a copy of your file

Range("A:B").SpecialCells(xlCellTypeBlanks).EntireRow.Delete

Thank you