use a case statement

Select case n
case 1 to 20
macro1
case 21 to 40
macro2


End Select

--
Regards,
Tom Ogilvy

"Rob947" wrote in message
lkaboutsoftware.com...
I have written 6 macros and want to choose to use 1 of them depending upon
the value of "n" in cell A1

If "n" = 1 through 20 use Macro 1
If "n" = 21 through 40 use Macro 2
If "n" = 41 through 60 use Macro 3
If "n" = 61 through 80 use Macro 4
If "n" = 81 through 100 use Macro 5
If "n" = 100 use Macro 6

Is this possible??