Non-contiguous print area

[papaexcel]

I have a data in A1:H50

I have three different print scenarios that I'd like to automate somehow.

1) I want to be able to print the whole selection (A1:H50)
2) I want to be able to print the top and bottom portion together (A1:H20, A41:H50)
3) and I want to be able to print the middle and bottom portion together (A21:H50)

I'm not sure scenario #2 is even possible. But if it is, I'd like to have a macro (or whatever is easiest) that allows me to click a button for the appropriate scenario. Clicking the button doesn't actually have to print the file, it just needs to set the print area.

Hope this makes sense.

Thanks!

[shg]

The print area is the same in all cases. Record three macros: One that hides rows 21:40, one that hides rows 1:20, and one that unhides all rows.

[papaexcel]

Sometimes I feel like an idiot when the answer is so simple. This would be one of those times.

Thanks!