FitToPagesTall Property

Applies To

PageSetup Object.

Description

Returns or sets how many pages tall the worksheet will be scaled to 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 FitToPagesWide 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