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