The FitToPagesDown property returns or sets the maximum number of pages down to print the worksheet. Returns a long.
Syntax
object.FitToPagesDown
object.FitToPagesDown = Pages
|
Parameter |
Type |
Description |
|
Pages |
Long |
required; number of pages |
Example 1
This example demonstrates how to return the maximum number of pages printed down.
Debug.Print WksPageSetup. FitToPagesDown
Example 2
This example demonstrates how to set the maximum number of pages printed down to four.
WksPageSetup. FitToPagesDown = 4
Used by: WksPageSetup object