Delete Rows that Do Not Contain Multiple Keywords

Hello,

I am trying to create a macro that will go through column A and delete all the rows that do not contain multiple keywords. Each time the macro is executed, the amount of keywords can change and this is where I am getting held up. I would imagine that an array would have to be used but I only know how to input an exact amount of keywords and not a variation of keywords each time.

The keywords in the rows I need to remain can contain alpha characters, numbers, or special characters as well. The code I use to search through and delete all but a single keyword is below but I need to apply it to a broader spectrum of keywords. Any help would be greatly appreciated.

Please Login or Register  to view this content.