This Excel tutorial explains how to use Excel INSTR Function for VBA, and explain difference among vbUseCompareOption, vbBinaryCompare and vbTextCompare.
Excel VBA INSTR Function
Excel INSTR function is used to search a substring (part of the string) within a string and return the position of the first occurrence.
For example, in the string "FinanceDepartment", the substring "Department" can be found at 8th position within "FinanceDepartment", the function will return number "8".
If we...
Read More