PageSetup 对象

属性 意义 值示例
PrintTitleRows 顶端标题行 ""
PrintTitleColumns 左端标题列 ""
PrintArea 打印区域 ""
LeftHeader 左标题 ""
CenterHeader 中标题 ""
RightHeader 右标题 ""
LeftFooter 左脚注 ""
CenterFooter 中脚注 ""
RightFooter 右脚注 ""
LeftMargin 左边距 Application.InchesToPoints(0.393700787401575)
RightMargin Application.InchesToPoints(0.275590551181102)
TopMargin Application.InchesToPoints(0.984251968503937)
BottomMargin Application.InchesToPoints(0.984251968503937)
HeaderMargin 页眉 Application.InchesToPoints(0.511811023622047)
FooterMargin 页脚 Application.InchesToPoints(0.511811023622047)
PrintHeadings   False
PrintGridlines 网格线 True
PrintComments   xlPrintNoComments
PrintQuality 打印分辨率 600
CenterHorizontally 水平居中 False
CenterVertically 垂直居中 False
Orientation 方向 Public Const xlPortrait = 1 '纵向
Public Const xlLandscape = 2 ' 横向
Draft   False
PaperSize 纸张型号 xlPaperA4
FirstPageNumber 首页页码 xlAutomatic
Order 顺序 xlDownThenOver
BlackAndWhite 黑白效果 False
Zoom 缩放比例 100

PaperSize 纸型

常量 意义
Public Const xlPaperLetter = 1 Letter (8-1/2 in. x 11 in.)
Public Const xlPaperLetterSmall = 2 Letter Small (8-1/2 in. x 11 in.)
Public Const xlPaperTabloid = 3 Tabloid (11 in. x 17 in.)
Public Const xlPaperLedger = 4 Ledger (17 in. x 11 in.)
Public Const xlPaperLegal = 5 Legal (8-1/2 in. x 14 in.)
Public Const xlPaperStatement = 6 Statement (5-1/2 in. x 8-1/2 in.)
Public Const xlPaperExecutive = 7 Executive (7-1/2 in. x 10-1/2 in.)
Public Const xlPaperA3 = 8 A3 (297 mm x 420 mm)
Public Const xlPaperA4 = 9 A4 (210 mm x 297 mm)
Public Const xlPaperA4Small = 10 A4 Small (210 mm x 297 mm)
Public Const xlPaperA5 = 11 A5 (148 mm x 210 mm)
Public Const xlPaperB4 = 12 B4 (250 mm x 354 mm)
Public Const xlPaperB5 = 13 B5 (182 mm x 257 mm)
Public Const xlPaperFolio = 14 Folio (8-1/2 in. x 13 in.)
Public Const xlPaperQuarto = 15 Quarto (215 mm x 275 mm)
Public Const xlPaper10x14 = 16 10 in. x 14 in.
Public Const xlPaper11x17 = 17 11 in. x 17 in.
Public Const xlPaperNote = 18 Note (8-1/2 in. x 11 in.)
Public Const xlPaperEnvelope9 = 19 Envelope #9 (3-7/8 in. x 8-7/8 in.)
Public Const xlPaperEnvelope10 = 20 Envelope #10 (4-1/8 in. x 9-1/2 in.)
Public Const xlPaperEnvelope11 = 21 Envelope #11 (4-1/2 in. x 10-3/8 in.)
Public Const xlPaperEnvelope12 = 22 Envelope #12 (4-1/2 in. x 11 in.)
Public Const xlPaperEnvelope14 = 23 Envelope #14 (5 in. x 11-1/2 in.)
Public Const xlPaperCsheet = 24 C size sheet
Public Const xlPaperDsheet = 25 D size sheet
Public Const xlPaperEsheet = 26 E size sheet
Public Const xlPaperEnvelopeDL = 27 Envelope DL (110 mm x 220 mm)
Public Const xlPaperEnvelopeC3 = 29 Envelope C3 (324 mm x 458 mm)
Public Const xlPaperEnvelopeC4 = 30 Envelope C4 (229 mm x 324 mm)
Public Const xlPaperEnvelopeC5 = 28 Envelope C5 (162 mm x 229 mm)
Public Const xlPaperEnvelopeC6 = 31 Envelope C6 (114 mm x 162 mm)
Public Const xlPaperEnvelopeC65 = 32 Envelope C65 (114 mm x 229 mm)
Public Const xlPaperEnvelopeB4 = 33 Envelope B4 (250 mm x 353 mm)
Public Const xlPaperEnvelopeB5 = 34 Envelope B5 (176 mm x 250 mm)
Public Const xlPaperEnvelopeB6 = 35 Envelope B6 (176 mm x 125 mm)
Public Const xlPaperEnvelopeItaly = 36 Envelope (110 mm x 230 mm)
Public Const xlPaperEnvelopeMonarch = 37 Envelope Monarch (3-7/8 in. x 7-1/2 in.)
Public Const xlPaperEnvelopePersonal = 38 Envelope (3-5/8 in. x 6-1/2 in.)
Public Const xlPaperFanfoldUS = 39 U.S. Standard Fanfold (14-7/8 in. x 11 in.)
Public Const xlPaperFanfoldStdGerman = 40 German Standard Fanfold (8-1/2 in. x 12 in.)
Public Const xlPaperFanfoldLegalGerman = 41 German Legal Fanfold (8-1/2 in. x 13 in.)
Public Const xlPaperUser = 256 用户自定义