Delete Row if Contains Blank Cell

Hello

Please see attachment for example data.

I have a code that searches in column B and if the cell contains either the words "Employee" or "Overall Total:", then it deletes the entire row.

Please Login or Register  to view this content.

How can I edit the code so that it also deletes the row if the cell in B is blank?

I have tried editing this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

but it deletes every row on the sheet.

Thank you in advance.

No that didn't work. Thank you though.

You can use filter but you got be careful with the name of a table.

Please Login or Register  to view this content.

Thank you for this, but it doesn't delete the blank cells.

Please Login or Register  to view this content.

It's coming up with error message : Can't move cells in a filtered range or table.

I've removed/cleared all filters and yet still won't work.

Yes - yours comes up with error 1004 : Delete method of Range class failed

I run the code and did not get an error. Could you attach the sample with the error?

This is the sample which gets the error message

Figured it out guys! It's because I had hidden columns that must have had a filter on. Once I unhid and removed filter, it worked.

Thank you both!

Figured it out guys! It's because I had hidden columns that must have had a filter on. Once I unhid and removed filter, it worked.

Thank you both!