InStr() format for text?

[bobkap]

I've tried to figure out how to find specific text in a string of text and darned if I can. In the example below I am trying to find the city name San Jose in a long string of text and then have San Jose stated in another column. However, when I use this code below, I get San Jose populated in that other column even when it's NOT in my original string. What am I doing wrong?

If InStr((Cells(mirow, micol)), "San Jose")" = 0 then
Cells(mirow,micol +1) = "San Jose"
End if
next line of code here etc

Any help would be greatly appreciated.

 

[Eric W]

Try:

If InStr((Cells(mirow, micol)), "San Jose")" > 0 then
     Cells(mirow,micol +1) = "San Jose"
End if