Hi

Would anyone be able to advise of the vb code to search a column of text for an exact match and return the row number?

I have a column of data strings such as "13ABCD00012", "13DFER00118" etc. I have a txtbox "txtPO" which contains the search stricg, say "118". With the code, I want to search the column of data strings for a string that contains "118", say. In this example, it would result in finding
"13DFER0018" and return, say, 65 as the row number in that column where the full string is.

Hope this makes sense and hope someone could advise.

Cheers