Hi, [Sorry posted in setup originally - now in right area] I have a report where I need to format the two pages to be one in portrait and one in landscape. I know I have done this before but cant figure out how to achieve this. I have tried highlighting two separate areas before hitting 'set print area' but I still can't control each page individually. Any clues? Regards, Nigel
Two separate print jobs. I don't know how you did it before.......maybe with a macro? Gord Dibben MS Excel MVP On Tue, 13 Nov 2007 06:19:05 -0800, ndrinkwater wrote: >Hi, > >[Sorry posted in setup originally - now in right area] > >I have a report where I need to format the two pages to be one in portrait >and one in landscape. I know I have done this before but cant figure out how >to achieve this. I have tried highlighting two separate areas before hitting >'set print area' but I still can't control each page individually. > >Any clues? > >Regards, > >Nigel
