PaperSize Property

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

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