Need help on how to exclude a row previously commanded to be removed

[alycat57]

I currently have created a Macro to eliminate a row if column "C" and "I" within that row are both blank. Unfortunately I need an exception to that should there be a key word found in column "J" (there are actually 3 different words to look for). Is there a way to do this?

[walruseggman]

Not sure how your looping through rows, so just as an example:

Please Login or Register  to view this content.

[alycat57]

Thank you for your response, I should have included the macro code, including it now:

Dim lr As Long, r As Long
lr = Cells(Rows.Count, "C").End(xlUp).Row
For r = lr To 1 Step -1
If Range("C" & r).Value = "" And Range("I" & r).Value = "" Then Rows(r).Delete
If Range("J" & r).Value = "" Then Rows(r).Delete
Next r
End Sub

I attempted your code as well as trying to put the first row of it into mine, same result.

[walruseggman]

In the future, please put your code in CODE tags, the # sign in the text editor tool bar.

Please Login or Register  to view this content.