Tony,

It's a little odd that you want a different layout for data that's in the same sheet. It's
likely that you have stuff (the stuff that prints on pages 9 and 10) that should be in a
separate sheet. Often folks put stuff in separate sheets where it should be in one. I've
written about this many times, and it's in "Data across Multiple Sheets" at
http://www.smokeylake.com/excel/excel_truths.htm. But in your case, you may have put stuff
into one sheet that should be in separate sheets. If you put the data in separate sheets,
you can set the second sheet to Landscape (File - Page setup), then print both sheets as a
single job (either select both sheets, or print the entire workbook). The page numbering
and everything should work out pretty much the same, print-wise.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"TonyR" wrote in message
...
I have a worksheet where the first 8 pages need to be in Portrait mode, all
with a consistent set of column widths.

Pages 9 and 10 need to be in Landscape, with different sets of column widths
(different from each other and different from the first 8 pages).

Is this possible and, if so, how?