PageSetup.PrintErrors property (Excel)

Sets or returns an XlPrintErrors constant 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 A variable that represents a PageSetup object.


In this example, Microsoft Excel uses a formula that returns an error on 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 that 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. 
End Sub

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.