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