PageSetup Members

Use the PageSetup object to control the printer settings for a worksheet or chart. Use the Worksheet and Chart objects’ PageSetup property to get a reference to this object. The PageSetup object has the following members . Key members (shown in bold) are covered in the following reference section:

Application

BlackAndWhite

BottomMargin

CenterFooter

CenterFooterPicture

CenterHeader

CenterHeaderPicture

CenterHorizontally

CenterVertically

ChartSize

Creator

Draft

FirstPageNumber

FitToPagesTall

FitToPagesWide

FooterMargin

HeaderMargin

LeftFooter

LeftFooterPicture

LeftHeader

LeftHeaderPicture

LeftMargin

Order

Orientation

PaperSize

Parent

PrintArea

PrintComments

PrintErrors

PrintGridlines

PrintHeadings

PrintNotes

PrintQuality

PrintTitleColumns

PrintTitleRows

RightFooter

RightFooterPicture

RightHeader

RightHeaderPicture

RightMargin

TopMargin

Zoom

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial