FitToPagesWide Property

Applies To

PageSetup Object.

Description

Returns or sets how many pages wide the worksheet will be scaled when it is printed. The Zoom property must be False, or this property is ignored. Read-write.

Remarks

If this property is False, Microsoft Excel scales the worksheet according to the FitToPagesTall property.

This property applies only to worksheets.

Example

This example causes Sheet1 to print exactly one page wide and tall.

With Worksheets("Sheet1").PageSetup
    .Zoom = False
    .FitToPagesTall = 1
    .FitToPagesWide = 1
End With