You can use ViewCustom Views to set up two different print ranges for your
users to pick from.

Or you could use a macro to print a selected range

You can use the name of the custom view as a parameter in your macro or just
direcly name the range to print.

I prefer the custom views method because you can hide rows and columns within
one print range.


Gord Dibben MS Excel MVP

On Thu, 4 Jan 2007 11:36:01 -0800, zip82dah
wrote:

I am working with new Excel users. I have a worksheet that sometimes needs
one print range and sometimes another. How can I predefine those ranges so
the users can just select PrintArea1 or PrintArea2?