Lots of ways. A cell with 1 or 2 and a macro or an input box in the macro

--
Don Guillett
SalesAid Software

"zip82dah" wrote in message
...
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?