HELP!!! Promelem with InStr(1, c, Sheets("TEG").Cells(i, 18), 1) >

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Almost got me!! the string to search in is first, then your criteria
InStr(1,Sheets("TEG").Cells(i, 18),c, 1)
 
Thanks a lot. That work. I am very greatful

John Bundy said:
Almost got me!! the string to search in is first, then your criteria
InStr(1,Sheets("TEG").Cells(i, 18),c, 1)
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hard time with If InStr(1, .. 3
When found add it to the last and display total in Msgbox 23
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Copy Array to Array, how to and should I? 13
Macro to Combine Data from Multiple Sheets with Cell References 4
Post to a Sheet Depending on a Value within a Cell Q 5
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Help with validations in Excel 1

Back
Top