The PageSetup property 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 percent of its actual size.
Debug.Print Wks.PageSetup.AdjustToPercentage = 75
Used by: WksDocument object