Edit

Share via

PageSetup.PrintQuality property (Excel)

  • Article

Returns or sets the print quality. Read/write Variant.

Syntax

expression.PrintQuality (Index)

expression A variable that represents a PageSetup object.

Parameters

Name Required/Optional Data type Description
Index Optional Variant Horizontal print quality (1) or vertical print quality (2). Some printers may not support vertical print quality. If you don't specify this argument, the PrintQuality property returns (or can be set to) a two-element array that contains both horizontal and vertical print quality.

Example

This example sets the print quality on a printer with non-square pixels. The array specifies both horizontal and vertical print quality. This example may cause an error, depending on the printer driver you are using.

Worksheets("Sheet1").PageSetup.PrintQuality = Array(240, 140)

This example displays the current setting for horizontal print quality.

MsgBox "Horizontal Print Quality is " & _ 
 Worksheets("Sheet1").PageSetup.PrintQuality(1)

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.