Search Array of strings for an exact match of string containing more than one word (case insensitive)

[sctlippert2]

This code works, but only if it is one word... how do I change it to look for an exact phrase?

If InStr(1, ArrayContainingStrings(i, 1), WORD, vbTextCompare) <> 0 then

 

[Fluff]

Duplicate to: Search Array of strings for an exact match of string containing more than one word (case insensitive)

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.