Thread: HELP!!! Promelem with InStr(1, c, Sheets("TEG").Cells(i, 18), 1)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ayo Ayo is offline
external usenet poster
  
Posts: 489
Default HELP!!! Promelem with InStr(1, c, Sheets("TEG").Cells(i, 18), 1)
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
Reply With QuoteReply With Quote