FitToPagesTall Property Example

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

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