We have a very large docuement and all but one page fits fine using portrait
but one page is just to big and needs to be landscape but I can't figure out
how to change that one page and leave the reset at portrait.

Thanks so much for your help

Hi Dawn,
You can't, you will have to move the material to another
worksheet. You can print both at the same time.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Dawn" wrote in message ...
We have a very large docuement and all but one page fits fine using portrait
but one page is just to big and needs to be landscape but I can't figure out
how to change that one page and leave the reset at portrait.

Thanks so much for your help

What you can also do is select all 'Lanscape' types sequentially and then
start selecting 'Portrait' orientations (using control Key and Print Area).
Not that you will be able to print all the pages in different orientations
using one 'Print' click instead you can give two print commands - One for all
Landscapes say 1-5 and one for all Portraits say 6-10. Can't say if this can
again be sorted out using a macro!

"Dawn" wrote:

We have a very large docuement and all but one page fits fine using portrait
but one page is just to big and needs to be landscape but I can't figure out
how to change that one page and leave the reset at portrait.

Thanks so much for your help