I have an array of strings that I want to check a variable, strName, against, but for some of the values in the array I just want to see if strName exists anywhere within the array element. For other elements I want to check if strName is equal to the entirety of the array element.
Do I need 2 arrays, one for the those elements I need to check using InStr and one for those I need to check using equals? Or is there a way of doing this with a single array?
Also posted here: http://www.mrexcel.com/forum/e…omething.html#post4576931