Thanks a lot. That work. I am very greatful

"John Bundy" wrote:

Almost got me!! the string to search in is first, then your criteria
InStr(1,Sheets("TEG").Cells(i, 18),c, 1)
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Ayo" wrote:

Can someone please tell me what is wrong with this line of code, the return
value is constant at zero even when the value of c is within
Sheets("TEG").Cells(i, 18)
i.e.
c = NYNYNJ3440 and,
Sheets("TEG").Cells(i, 18) = W-440 NYNYNJ3440- Midland Park DPW


Thank you.

Ayo