different sections of the same sheet in landscape and portrait

G

Guest

I am trying to print different sections of the same sheet in landscape and portrait. I use office 2003
 
F

Frank Kabel

Hi
you may try the following macro

Sub print_different()

With ActiveSheet.PageSetup
.PrintArea = "$A$1:$C$16"
.Orientation = xlPortrait
End With
ActiveWindow.SelectedSheets.PrintOut

With ActiveSheet.PageSetup
.PrintArea = "$A$17:$C$26"
.Orientation = xlLandscape
End With
ActiveWindow.SelectedSheets.PrintOut
End Sub

Change the two ranges according to your spreadsheet layout
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel charts will not go back to Landscape when selected 2
Excel 2007: Printing both in Landscape and Portrait in one run 2
Word Printing and Rotation of Landscaped Pages 2
Landscape selected but printout persists in portrait. How to fix? 1
Printing landscape and portrait 3
Landscape Portrait 2
how to embed print instruction portrait landscape in excel 2
print one page landscape and one page portrait 2

Top