Applies To
PageSetup Object.
Description
Windows only. Returns or sets the size of the paper. Read-write.
Remarks
This property may have one of the following values.
|
Value |
Meaning |
|
xlPaperLetter |
Letter (8 1/2 x 11 in.) |
|
xlPaperLetterSmall |
Letter Small (8 1/2 x 11 in.) |
|
xlPaperTabloid |
Tabloid (11 x 17 in.) |
|
xlPaperLedger |
Ledger (17 x 11 in.) |
|
xlPaperLegal |
Legal (8 1/2 x 14 in.) |
|
xlPaperStatement |
Statement (5 1/2 x 8 1/2 in.) |
|
xlPaperExecutive |
Executive (7 1/2 x 10 1/2 in.) |
|
xlPaperA3 |
A3 (297 x 420 mm) |
|
xlPaperA4 |
A4 (210 x 297 mm) |
|
xlPaperA4Small |
A4 Small (210 x 297 mm) |
|
xlPaperA5 |
A5 (148 x 210 mm) |
|
xlPaperB4 |
B4 (250 x 354 mm) |
|
xlPaperB5 |
B5 (182 x 257 mm) |
|
xlPaperFolio |
Folio (8 1/2 x 13 in.) |
|
xlPaperQuarto |
Quarto (215 x 275 mm) |
|
xlPaper10x14 |
10 x 14 in. |
|
xlPaper11x17 |
11 x 17 in. |
|
xlPaperNote |
Note (8 1/2 x 11 in.) |
|
xlPaperEnvelope9 |
Envelope #9 (3 7/8 x 8 7/8 in.) |
|
xlPaperEnvelope10 |
Envelope #10 (4 1/8 x 9 1/2 in.) |
|
xlPaperEnvelope11 |
Envelope #11 (4 1/2 x 10 3/8 in.) |
|
xlPaperEnvelope12 |
Envelope #12 (4 1/2 x 11 in.) |
|
xlPaperEnvelope14 |
Envelope #14 (5 x 11 1/2 in.) |
|
xlPaperCsheet |
C size sheet |
|
xlPaperDsheet |
D size sheet |
|
xlPaperEsheet |
E size sheet |
|
xlPaperEnvelopeDL |
Envelope DL (110 x 220 mm) |
|
xlPaperEnvelopeC3 |
Envelope C3 (324 x 458 mm) |
|
xlPaperEnvelopeC4 |
Envelope C4 (229 x 324 mm) |
|
xlPaperEnvelopeC5 |
Envelope C5 (162 x 229 mm) |
|
xlPaperEnvelopeC6 |
Envelope C6 (114 x 162 mm) |
|
xlPaperEnvelopeC65 |
Envelope C65 (114 x 229 mm) |
|
xlPaperEnvelopeB4 |
Envelope B4 (250 x 353 mm) |
|
xlPaperEnvelopeB5 |
Envelope B5 (176 x 250 mm) |
|
xlPaperEnvelopeB6 |
Envelope B6 (176 x 125 mm) |
|
xlPaperEnvelopeItaly |
Envelope (110 x 230 mm) |
|
xlPaperEnvelopeMonarch |
Envelope Monarch (3 7/8 x 7 1/2 in.) |
|
xlPaperEnvelopePersonal |
Envelope (3 5/8 x 6 1/2 in.) |
|
xlPaperFanfoldUS |
U.S. Standard Fanfold (14 7/8 x 11 in.) |
|
xlPaperFanfoldStdGerman |
German Standard Fanfold (8 1/2 x 12 in.) |
|
xlPaperFanfoldLegalGerman |
German Legal Fanfold (8 1/2 x 13 in.) |
|
xlPaperUser |
User defined |
Some printers may not support all paper sizes.
Example
This example sets the paper size of Sheet1 to legal.
Worksheets("Sheet1").PageSetup.PaperSize = xlPaperLegal