MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Line in Macro to set paper orientation

Posted by Herb B. on November 10, 2001 1:03 PM

I have macros that print to different schedules, one that requires a landscape orientation and the other a portrait orienataion. How do I set these parameters before printing the schedules?

Posted by Paul on November 10, 2001 2:18 PM

With ActiveSheet.PageSetup
.Orientation = xlLandscape
End With
End Sub
.Orientation = xlPortrait