PageSetup.Orientation Property (Excel)
Returns or sets a XlPageOrientation value that represents the portrait or landscape printing mode.
Syntax
expression .Orientation
expression A variable that represents a PageSetup object.
Example
This example sets Sheet1 to be printed in landscape orientation.
Worksheets("Sheet1").PageSetup.Orientation = xlLandscape