Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

PageSetup Object

Office 2007
Represents the page setup description.

Remarks

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

Example

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

Visual Basic for Applications
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.

Visual Basic for Applications
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



Community Additions

Show: