I'm not sure I see how a select case method would reduce the number of lines...would it not be exactly the same?

Would you be able to provide an example of what you mean?