Double filter (condition) to delete rows

Hi, I'm using this code to delete a row if the condition is "satisfied"

Please Login or Register  to view this content.

but I need a condition that analize TWO cells on the same row, not just one like the code above

Thanks Nik

Hi thanks for your reply
unfortunately this is not really my job

I've tried to adapt your code but i receive an error on this line:
Rng.SpecialCells(xlCellTypeVisible).EntireRow.Delete

trying to rewrite the code specifically to my needs:
IF THE CELL IN COLUMN E CONTAINS "STRING1" AND CELL IN COLUMN F CONTAINS "STRING2"
THAN DELETE ENTIRE ROW

looking forward to your reply

Nik

Hi Nik,

Try this by placing in a module:

Please Login or Register  to view this content.

Excellent !

It works !

I've noticed that is much quicker than my old code

Thank you very much

Glad I could help!