Show All

PrintErrors Property

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 .

expression   Required. An expression that returns one of the objects in the Applies To list.

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.

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.PrintErrors = xlPrintErrorsDash

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

End Sub