Re: More structured version...

>Also, how can you have multiple conditions with select case?

You mean on the same CASE? Use comma as a separator:

CASE 1,3,5,7, is <=-5, 100 to 200, 205

Regards,
Michael