PaperSize Property
PaperSize returns or sets the paper size for the worksheet. Returns an object.
Syntax
object.PaperSize
object.PaperSize = Size
|
Parameter |
Type |
Description |
|
Size |
required |
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