VBASearching within strings for the presence of substrings
When you need to check for the presence or position of a substring within a string, VBA offers the
InStrRev functions that return the character position of the substring in the string, if it is present.
Use InStr to determine if a string contains a substring
This modified text is an extract of the original Stack Overflow Documentation created by following contributors
and released under CC BY-SA 3.0