PageSetup Object [Excel 2003 VBA Language Reference]

  • Article
Multiple objects
PageSetup
Graphic

Represents the page setup description. The PageSetup object contains all page setup attributes (left margin, bottom margin, paper size, and so on) as properties.

Using the PageSetup Object

Use the PageSetup property to return a PageSetup object. The following example sets the orientation to landscape mode and then prints the worksheet.

With Worksheets("Sheet1")
    .PageSetup.Orientation = xlLandscape
    .PrintOut
End With

The With statement makes it easier and faster to set several properties at the same time. The following example sets all the margins for worksheet one.

With Worksheets(1).PageSetup
    .LeftMargin = Application.InchesToPoints(0.5)
    .RightMargin = Application.InchesToPoints(0.75)
    .TopMargin = Application.InchesToPoints(1.5)
    .BottomMargin = Application.InchesToPoints(1)
    .HeaderMargin = Application.InchesToPoints(0.5)
    .FooterMargin = Application.InchesToPoints(0.5)
End With

Properties | Application Property | BlackAndWhite Property | BottomMargin Property | CenterFooter Property | CenterFooterPicture Property | CenterHeader Property | CenterHeaderPicture Property | CenterHorizontally Property | CenterVertically Property | ChartSize Property | Creator Property | Draft Property | FirstPageNumber Property | FitToPagesTall Property | FitToPagesWide Property | FooterMargin Property | HeaderMargin Property | LeftFooter Property | LeftFooterPicture Property | LeftHeader Property | LeftHeaderPicture Property | LeftMargin Property | Order Property | Orientation Property | PaperSize Property | Parent Property | PrintArea Property | PrintComments Property | PrintErrors Property | PrintGridlines Property | PrintHeadings Property | PrintNotes Property | PrintQuality Property | PrintTitleColumns Property | PrintTitleRows Property | RightFooter Property | RightFooterPicture Property | RightHeader Property | RightHeaderPicture Property | RightMargin Property | TopMargin Property | Zoom Property

Parent Objects | Chart Object | Worksheet Object

Child Objects | Graphic Object