PrintErrors Property

Microsoft Excel Visual Basic

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 .

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

expression.PrintErrors

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