PivotTable.DisplayErrorString (Excel)

True if the PivotTable report displays a custom error string in cells that contain errors. The default value is False.

Use the ErrorString property to set the custom error string. This property is particularly useful for suppressing divide-by-zero errors when calculated fields are pivoted.

ActiveCell.PivotTable.DisplayErrorString = True