Share via


PageSetup.PrintErrors Property

Excel Developer Reference

Sets or returns an XlPrintErrors contstant specifying the type of print error displayed. This feature allows users to suppress the display of error values when printing a worksheet. Read/write .

Syntax

expression.PrintErrors

expression   A variable that represents a PageSetup object.

Remarks

XlPrintErrors can be one of these XlPrintErrors constants.
xlPrintErrorsBlank
xlPrintErrorsDash
xlPrintErrorsDisplayed
xlPrintErrorsNA

Example

In this example, Microsoft Excel uses a formula that returns an error in the active worksheet. The PrintErrors property is set to display dashes. A Print Preview window displays the dashes for the print error. This example assumes a printer driver has been installed.

Visual Basic for Applications
  Sub UsePrintErrors()
Dim wksOne As Worksheet

Set wksOne = Application.ActiveSheet

' Create a formula that returns an error value.
Range("A1").Value = 1
Range("A2").Value = 0
Range("A3").Formula = "=A1/A2"

' Change print errors to display dashes.
wksOne.PageSetup.<strong class="bterm">PrintErrors</strong> = xlPrintErrorsDash

' Use the Print Preview window to see the dashes used for print errors.
ActiveWindow.SelectedSheets.PrintPreview

End Sub

See Also