Auto Filter to delete Rows on Multiple criterion

[swade730]

Hi,

I want to delete a row if the text in a particular column is nbot one of 5 different words in particular.

How can I alter this cde to make it apply to multiple criteria.

Please Login or Register  to view this content.

Please Advise,

Thank You

[walruseggman]

Try this. Change all the "Test" values in MyArr to whatever you other 4 values are.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

FWIW:

Please Login or Register  to view this content.