PivotTable.ErrorString (Excel)

Returns or sets a String value that represents the string displayed in cells that contain errors when the DisplayErrorString property is True.

The default value for this property is an empty string ("").

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