PageSetup.PrintErrors (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. Possible return values are xlPrintErrorsBlank - Print errors are blank, xlPrintErrorsDash - Print errors are displayed as dashes, xlPrintErrorsDisplayed - All print errors are displayed, xlPrintErrorsNA - Print errors are displayed as not available.


Worksheets("Sheet1").PageSetup.PrintErrors = xlPrintErrorsBlank