Remove row containing criteria from a list - not static criteria

Hello,

I have a macro I use to filter a large file that I receive each day. Each row of data has an identifier in column C, and this is where the macro looks to determine whether or not to remove that row. Currently, my macro will only remove rows in which column C contains any of the following strings: "B0A0", "B0MH", or "SRB". This part of the macro looks like this:

Please Login or Register  to view this content.

I want to add additional functionality to this macro. I will always need rows removed where the identifier in column C contains one of these static strings, but there are times when there or other strings that I would like the macro to remove. Ideally, I'd like to have a range on a worksheet where I can type a string of characters in each cell, and the macro will look to this range when removing rows in my large file. How can I modify this existing code to incorporate this?

Say, for example, that I want to designate the range B2:B50 on Sheet 4 as the range where I want to type these strings.

Thanks in advance for taking the time to read and for your assistance!

-Student1990

Try this:-

Please Login or Register  to view this content.

Regards Mick

Thank you, Mick. That was exactly what I was looking for. Your modification enables me to use a range as my criteria for filtering. Thanks!