PivotTable.ErrorString property (Excel)

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


expression. ErrorString

expression A variable that represents a PivotTable object.


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


This example displays a hyphen in cells in the specified PivotTable report that contain errors.

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

See also

PivotTable Object