Heather,
The "InStr" Function does what you want.
It returns a Variant (Long) specifying the position of the first occurrence
of one string within another.
Jim Cone
San Francisco, USA
"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