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

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

Try:

Instr(1, Sheets("TEG").Cells(i, 18).Text, c, 1)


In article ,
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

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

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

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

The .Text didn't work.

"JE McGimpsey" wrote:

Try:

Instr(1, Sheets("TEG").Cells(i, 18).Text, c, 1)


In article ,
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

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

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

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

Then you didn't have what you said you had in the cell...

In article ,
Ayo wrote:

The .Text didn't work.

"JE McGimpsey" wrote:

Try:

Instr(1, Sheets("TEG").Cells(i, 18).Text, c, 1)


In article ,
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