Hello again, Paul (and any others)...

I have a follow up question to the solution you folks have offered, which works great for the issue I was working on at the time. Your solution finds the keyword as long as the keyword is the lone item in a cell in the selected range.

My new question that I have thus far been unable to figure out is: How to search for a keyword in a range of strings in a closed workbook. For example, my closed w/b column B17:B52 contains many lines of text. A simple example below:
Range Text
B17 The quick brown fox
B18 jumps over the lazy dog
B19 and the fat black cat
B20 is nowhere to be found

Let's say I want to search for the keyword "cat". All I'm looking for is a true/false as to whether the keyword appears anywhere in the strings of text found in range B17:B52 of the closed w/b. Also (not sure if this matters or not), range B17:B52 cells are merged cells. In other words, selecting cell B17 selects cells B17:T17, as they are merged.

The simple (and very fast) solution that you had offered to my previous question is SO close to doing what I need to do now, but I'm stuck.

Also, I'm new to this site, so I'm not sure if I should have started a completely new thread or follow up with this one, since it seems so close...

Thank you in advance for any help.