PageSetup Property [WksDocument]

 

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