Return True or false value if string is found in range

[Prevost]

Hi There,
I am wondering if there is a function in excel that would return true or false when searching for a string segment. I am currently using the below code to evaluate my search, which seems to be working, but I was just wondering if anyone knew of anything else out there?
Thanks!

If InStr(1, ActiveCell.Value, "My String") <> 0 Then

 

[sheetspread]

find or search

 

[Rick Rothstein]

This will work...

If WorksheetFunction.CountIf(Range("[COLOR=#008000][B]A1:F100[/B][/COLOR]"), "[COLOR=#FF0000][B]*[/B][/COLOR]My String[COLOR=#FF0000][B]*[/B][/COLOR]") Then

Replace the green text with the address for the range you want to search and note the two required asterisks (needed if you are not going to match all the text in a cell) highlighted in red on either side of text being searched for.