You could try using Instr that will return a value 0 if the string is
found. e.g.

If Instr(string1, string2) 0 then
'found
else
'not found
end if

Where string2 is the string to search for in string1. It is case sensitive
as shown
--
Cheers
Nigel



"oodam" wrote in message
...

I'm trying to use a formula that will check the contents of a cell and
color the cell's row accordingly. However, the "keywords" that I'm
looking for won't be the only thing in the cell - they will most likely
be part of a sentence.
With regular formulas, I found that just putting asterisks around the
keywork insde quotation marks works fine. In VBA, though, that doesn't
seem to work.
Any ideas?


--
oodam
------------------------------------------------------------------------
oodam's Profile:
http://www.excelforum.com/member.php...o&userid=35513
View this thread: http://www.excelforum.com/showthread...hreadid=553317