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