PageSetup.PrintErrors Property

  • Article
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