PageSetup Property

The PageSetup property returns the AutoPageSetup object for the plot document or the WksPageSetup object for the worksheet. This is a read-only property.

Syntax

object.PageSetup

object.PageSetup = PageSetup

Example 1

This example demonstrates how to return the orientation of a plot document.

Debug.Print Plot.PageSetup.Orientation

Example 2

This example demonstrates how to set the right margin of a plot document to one page unit.

Plot.PageSetup.RightMargin = 1

Example 3

This example demonstrates how to return whether or not worksheet contents are centered vertically when printed.

Debug.Print Wks.PageSetup.CenterVertically

Example 4

This example demonstrates how to print a page reduced to 75 percent of its actual size.

Wks.PageSetup.AdjustToPercentage = 75

 

Used by: Document object, Worksheet object