How to check for 2 criteria for an action

[2shlee]

Hello everyone, I'm fairly new to macros and I need your help.

How do I check for 2 criteria in the same row and have an action based on that criteria?

What's the macro we would use in the sheet that deletes the row if both columns B and C contain 0 but leaves it alone if it is blank throughout the entire sheet without hard coding?

Example:

2016-08-29_18-38-47.png

Thank you!

[GC Excel]

Hi 2shlee and welcome to the forum,

Here's an code example that will delete rows where B and C = 0
(only if there is a value in B and C)

Please Login or Register  to view this content.

[jolivanes]

Different approach, same result (I think).

Please Login or Register  to view this content.

[2shlee]

Different approach, same result (I think).

Please Login or Register  to view this content.

This worked, but the code is very peculiar.

So I ran the Macro and it did as it's supposed to. I added additional lines below with new names and criteria of 0 & 0 for both column B and C and all the sudden it didn't run properly (do as intended). Why is this the case?

[jolivanes]

Don't know. I don't have your workbook to check. As long as it is zero's (0) and not capital o's (the alphabet 15th letter), it should work I would say.
How about GC Excel's code. Use it if that works OK.
How are the zero's entered?
Just for the heck of it. I tried again and added a bunch with zero's in Column B and C and it worked OK.