AdjustToPercentage Property

AdjustToPercentage 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

Example 1

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

Debug .Print WksPageSetup.AdjustToPercentage

Example 2

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

WksPageSetup.AdjustToPercentage = 75

Used by: WksPageSetup object