Before you go off on that array solution, take a good look at RhinoBull's second suggestion in his first post. Using the Select Case statement can put all the options into one statement. Whether this is actually faster than looping through the arrays, would have to be tested, since I don't know how VB would implement the Select, but I would expect it to be faster.