use instr function to find the string......

instr will return zero if not found or a number 0 showing the start of the
search string

eg ... search in range A1 for string abc, the 1 at the beginning refers to
the starting position of the string you are searching...

If instr(1,Range("A1"),"abc") 0
MsgBox "Found It!"
Else
MsgBox "Not Found"
End If

instr is case sensitive so use UCase to convert strings if this is not
important

--
Cheers
Nigel



"peacelittleone"
<peacelittleone.1tawim_1123261540.0021@excelforu m-nospam.com wrote in
message news:peacelittleone.1tawim_1123261540.0021@excelfo rum-nospam.com...

Say I have a string = "abc".
Say I have a cell value = "123 abc 456 def"

In VB how do I findout if the cell value contains my string?

Right now I am trying this: (which of course doesn't work)

Set Found = Find(c.Value, req.Value, 1)

Where c is my string and req is the cell value I want to look in.

TIA!!!!

Heather.


--
peacelittleone


------------------------------------------------------------------------
peacelittleone's Profile:
http://www.excelforum.com/member.php...o&userid=20937
View this thread: http://www.excelforum.com/showthread...hreadid=393364