Search range for multiple strings

I have 3 cells that may contain a 3 or 4 character string. I need to search the 3 cells to see if any of them contain any of the following strings; ABC, DEF, GHIJ. Any or all of the 3 cells may be blank or may contain strings different than the three I am looking for.

I can accomplish this with the attached code. However, in the real application, I must search 5 cells for 9 possibilities and the code seems to get cumbersome.
Is there a more concise way to accomplish the same thing?

Thanks for your consideration.

Please Login or Register  to view this content.

Thanks for the reply.

My code is Option Explicit and I get a Variable not defined error. I tried to declare arr as string but that resulted in a Type mismatch error. When I declare the arr as Variant the code works fine. Do I have to declare arr as Variant ?

Thanks again.

That did work fine!
Your code is so much simpler than what I had constructed. I will be able to incorporate it nicely into my work.
Thread marked "Solved".

Thanks again.