Hi Folks,
I would like to create a list of string values for an Instr Function, rather than having to write numerous statements covering each of them.
I'm thinking that its easier and more flexible to add to a list, than to write additional code.
So, is it possible to replace the Second String arg of the Instr Function with either of these two options?
InStr([start, ]string1, string2[, compare])
- an array of values
- a named range of values on a sheet
How would these be dimensioned?
How would the variables be set?
I've tinkered with a few variations, but I get all sorts of mismatch errors and procedural bugs.
Thanks,
Mark
Bookmarks