Delete entire row if cell is blank or contains [Excel VBA]

Excel VBA code to delete entire row if the cell is blank or empty or cell is ‘xx’ or cell contains ‘xx’.

Case 1: Delete entire row, if cell is empty

The macro checks the cell value, if it is empty or blank, then it deletes the entire row, else the cursor moves to the cell in the next row.

Case 2: Delete entire row, if cell value is ‘xx’

Just replace below line of above code

with

Case 3: Delete entire row if the cell contains ‘xx’ Ex: xx 1, use xx soap

Replace below line of above code

with