InStr function

[bobkap]

I am trying to see if a string contains a certain word or just letters like "ABC". This line of code I have works but ONLY if the word I'm looking for is at the very beginning of the string. If the word is say starting at the 5th character of the string I get a zero for the result. How should I write this so that I will get a hit no matter where my word is?

"If InStr((Cells(mirow, micol)), "ABC") = 1 Then"

 

[Michael M]

Why not simply

If InStr(Cells(mirow, micol), "ABC") Then

 

[bobkap]

Why not simply

If InStr(Cells(mirow, micol), "ABC") Then

That did it!! Thanks very much. Not sure why I made it so complicated.

 

[Michael M]

Glad it worked...