the sizzle sells the steak. try to enjoy your meat without minding the fact they forgot to drizzle lemon juice on the plate.
no excuse, that's for sure, but tgc has had to concenrate on the 'otherwise an awesome product' parts in order to lure you in here. there are shortcomings, deficiencies and workarounds in every language and products (otherwise i wouldn't have a job) and they are trying to work through them.
in the instance of the select range, you could always try hashing your numbers down, or use an interim step to evaluate the variable prior to the select, or better yet, encapsulate logic to be reused in functions.
the easiest solution would be to just use compound nested ifs. when it comes down to it, selects and ifs look identical in machine code and perform no differently.
cheers.
-= i only do what my rice krispies tell me to do =-
