The PageOrientation property defines the page’s orientation, allowing you to choose between portrait or landscape modes. Setting the PageOrientation property is equivalent to assigning a value to the Settings(exPageOrientation) property. It is important to set the PageOrientation property before modifying any other printer settings through the Settings property. Use the Settings property to adjust additional printer options within the printer dialog.

The following sample changes specifies an A4 Landscape page, and specifies that margins must be measured in millimeters:

With Print1
    Set .PrintExt = Grid1.Object
    .PageOrientation = exLandscape
    .Settings(exDisplayInch) = 1
    .Settings(exPaperSize) = 9
    .Preview
End With