You would have to write a macro to do this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"willow" wrote in message
...
How can I set the print area on several pages of an Excell
workbook at one
time instead of having to set it one page at a time?