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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.