instr to get exact match

[Av8tordude]

I have this line of code, but I thought it was to get exact match. How can I get the exact match?

If InStr(1, Cells(RowNum, 1).Value, "BA", vbTextCompare) > 0 Then

 

[Fluff]

That will tell you if the cell contains BA, or ba, or Ba etc.
If that is not what you want, can you please explain

 

[Av8tordude]

EBAY has "BA" in it. I want to be able to find the exact string. if BA, then only BA. Not words with the letters BA

 

[Fluff]

How about

If Cells(RowNum,1)="BA" Then

 

[Av8tordude]

Ahhh....Thank you

 

[Fluff]

You're welcome