Search for every value in a certain range and delete any row that contains any

Hello! I have a macro that searches a worksheet for a word, and deletes any row that contains that word. I would like to, instead, use a range of words, and delete any row that contains any word in the range! Here is what I have so far.

Formula:

Please Login or Register  to view this content.

The Range I wish to use is D2:D20 on the worksheet "Config". This macro is going to be used on multiple different worksheets, but the range of words I'm going to use will always be Config!D2:D20.

Thank you for your time!

You could loop through D2:D20, something like:

Please Login or Register  to view this content.

Maybe I should be more clear. What I am looking for instead of

Formula:

Please Login or Register  to view this content.

is

Formula:

Please Login or Register  to view this content.

Or the equivalent of that. I'm not trying to remove rows from Range D2:D20, I'm USING that range to remove rows from a whole other Worksheet ("Config")

Tim,
It can be done with find function, but will do it slightly different to wend loop, but I would like to see a sample for testing.

I'll post one tomorrow morning. The sheet itself is on my office computer.

Here we go, this should do.

SampleBook2.xlsm

I've solved it! I changed to an If Then, and used an array for the Remove List.

Formula:

Please Login or Register  to view this content.

Tim,
Sorry!
I did not get back to you on time, but you have resolved it yourself.
Well done!
I was about to post very similar code, but you have got it.

Thanks for your time anyways. You've been very helpful to me!