if Not Instr() Issue

[ilcaa]

I cant see what the issue is with this if Not statement, it continues the IF statement even though it shouldnt. right??

b = "Just Listed"

If Not InStr(1, b, "Listed", 1) Then
msgbox "Not New"
End If

Loop

 

[VoG]

Try

If InStr(1, b, "Listed", 1) = 0 Then

 

[ilcaa]

yes that worked!

is that just a bug with vba using NOT Instr(), or it shouldnt be used like that??

thanks!

 

[VoG]

I don't think that you can use Not like that in a test for a numeric result in VBA. Not works fine when the result of a test is True or False.

 

[texasalynn]

try it with this

If InStr(1, b, "Listed", 1) = 0 Then

edit: DOH too slow