Macro required for deleting entire row based on whether there is any data in some cells

Hello Experts,

I am very very new to Excel macros. I want your assistance to create a macro which will delete the entire row if Cells A, B and C in an entire column of about 20000 rows is empty.
For example, if A1 is empty, B1 has something and C1 is empty, then it should not delete the row
But if A2 is empty, B2 is empty and C2 is empty, then the row should be deleted.

ie in the entire sheet, if the consequetive cells in columns A, B and C are empty, then the entire Row should be deleted.

Appreciate your quick assistance in this matter. Incase you need the entire excel sheet to be attached, I would be glad to do so.

Thanks and best regards,
Bala

Test this on a copy of your data. It assumes row 1 is a header row.

Please Login or Register  to view this content.