DisplayErrorString Property Example

This example causes the PivotTable report to display a hyphen in cells that contain errors.

With Worksheets(1).PivotTables("Pivot1")
    .ErrorString = "-"
    .DisplayErrorString = True
End With