PaperSize Property

The PaperSize property returns or sets the paper size for the worksheet. Returns a wksPaper object.

Syntax

object.PaperSize

object.PaperSize = Size

 

Parameter Type Description
Size wksPaper required, paper size

 

Example 1

This example demonstrates how to return size of paper used to print a worksheet.

Debug.Print WksPageSetup.PaperSize

Example 2

This example demonstrates how to set the paper size to letter.

WksPageSetup.PaperSize = wksPaperLetter

 

Used by: WksPageSetup object