Compare two cells, if blank delete entire row

I can delete rows based on one cell being blank but not the other. I have two columns and the data I am working on is in Column E and F. I need a macro or VBA because I could not figure out how to do it with conditonal formatting. If the cell in column E and F is blank then delete the entire row.

Example:
E2 and F2 is blank = Delete
E2 is blank but F2 has numbers = Do not delete

Hope that makes sense. Thank you.

taichi56,

Here is some code that will delete rows in a sheet where the cells are blank in both E and F for a particular row.

Please Login or Register  to view this content.

Hope it helps,

Daniel

Thank you. That worked wonderfully.