AdjustToPercentage Property

The AdjustToPercentage property returns or sets the printing enlargement or reduction percentage for the worksheet. A value of zero indicates that reduction should be done according to the FitToPagesAcross and FitToPagesDown settings. Returns a Long.

Syntax

object.AdjustToPercentage

object.AdjustToPercentage = Percentage

 

Parameter Type Description
Percentage Long required, percent value

 

Example 1

This example demonstrates how to return the enlarged or reduced percentage size of the page to be printed.

Debug.Print WksPageSetup.AdjustToPercentage

Example 2

This example demonstrates how to print a page reduced to 75 percent of its actual size.

WksPageSetup.AdjustToPercentage= 75

 

Used by: WksPageSetup object