Error 91 while finding strings

My code goes through a column of search patterns (strings) on one worksheet, looking for each one in column on another sheet, and marking an 'x' two columns over where-ever the string is found.

It works for many strings, but sometimes fails with error 91 for reasons that are unclear to me. Sometimes it's because of spaces in the string, special characters (* ' etc), or even just numbers in the string. I'm not sure what I'm doing wrong. I'd appreciate any insight folks can lend.

Please Login or Register  to view this content.

shg, thanks for your help.

I get a 438 (Object doesn't support this property or method) on this line:

Please Login or Register  to view this content.

Don't see what the problem is here.