Check to see if a cell contains a certain word
 

what vba function can check if a cell contains a certain word? I trie
the Search function, but it gives me an error message said undefine
function. Thanks

--
betty7
-----------------------------------------------------------------------
betty77's Profile: http://www.excelforum.com/member.php...fo&userid=3709
View this thread: http://www.excelforum.com/showthread.php?threadid=56931

Check to see if a cell contains a certain word
 

Look at Instr function.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"betty77" wrote in
message ...

what vba function can check if a cell contains a certain word? I tried
the Search function, but it gives me an error message said undefined
function. Thanks.


--
betty77
------------------------------------------------------------------------
betty77's Profile:
http://www.excelforum.com/member.php...o&userid=37092
View this thread: http://www.excelforum.com/showthread...hreadid=569310