PDA

View Full Version : How to set Multiple instr



alexandro88
11-08-2011, 10:50 PM
InStr(1, Left(rngcell.Value, 4), "Mon,"Tue","Wed", "Thur")

can i set the multiple instr like this?

mdmackillop
11-09-2011, 11:29 AM
You would need to loop through the values.

mikerickson
11-09-2011, 05:02 PM
Would something like
IsNumeric(Application.Match(Left(rngcell.Value, 4), Array("Mon ", "Tue ", "Wed ", "Thurs"}, 0)
work for your need?

mdmackillop
11-09-2011, 05:13 PM
Thurs?

mikerickson
11-09-2011, 07:08 PM
Thurs comes just before Fry.