Find string in range or cells

Hello,
Does anybody knows a way (function or VBS) to see if a range of cells contains a certain textstring and give than a true or false as answer.
Thanks
Frank

Try this:
=COUNTIF(A1:A100,"*Frank*")>0

Ola Sandstrom



I answered a similar question today
http://www.excelforum.com/showthread.php?t=348161
and added some But's under Note - that might be good to know.