Orientation Property [WksPageSetup]
The Orientation property returns or sets the page orientation (landscape or portrait) for the worksheet. Returns a Long.
Syntax
object.Orientation
object.Orientation = Orientation
Parameter | Type | Description |
Orientation | Long | required, wksOrientation |
Example 1
This example demonstrates how to return the orientation of a worksheet document to be printed.
Debug.Print WksPageSetup.Orientation
Example 2
This example demonstrates how to set a worksheet document to be printed in a portrait orientation.
WksPageSetup.Orientation = wksOrientationPortrait
Used by: WksPageSetup object