I guess this version will work properly even if there is no character
following the 'traf10' characters...

If Cell2Srch.Value & " " Like "*traf10[!6]*" Then

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
This should do the same thing PROVIDED there is always at least one
character following the 'traf10' characters...

If Cell2Srch.Value Like "*traf10[!6]*" Then

--
Rick (MVP - Excel)


"TomPl" wrote in message
...
I think the wild cards would make it look like this:

If Cell2Srch.Value Like "*traf10*" And Not Cell2Srch.Value Like
"*traf106*"
Then
Cells(Cell2Srch.Row, 1).Value = "Yes"
End If

Tom