InStrExact - Find Location Of A Word, As A Word, Not Embedded Within Another Word

[Rick Rothstein]

Hi Mr. Rick
I tested your great UDF function and noticed that case sensitive doesn't work properly

Sub TestRun()
    MsgBox InStrExact(1, "Don't tell me, but your name is Don, right?", "Don", 1)
End Sub

The optional argument case sensitive .. I tried to put 0 and 1 .. I got the same result 33
Is there any thing wrong about it?

Since the word you are searching for has the same letter casing as the word in the text, a case sensitive and case insensitive search will always return the same value. Try changing the red highlighted word to "don" instead of "Don" and then try 0 and 1 for the 4th argument to see the difference