PageSetup Property [WksDocument]

PageSetup returns the WksPageSetup object for the worksheet. This is a read-only property.

Syntax

object.PageSetup

Example 1

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

Debug.Print Wks.PageSetup.CenterVertically

Example 2

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

Debug.Print Wks.PageSetup.AdjustToPercentage = 75

Used by: WksDocument object

See Also

File | Page Setup