AdjustToPercentage Property

The AdustToPercentage 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

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