Share via

PivotTable.ErrorString Property

  • Article
Excel Developer Reference

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

Syntax

expression.ErrorString

expression   A variable that represents a PivotTable object.

Remarks

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

Example

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

Visual Basic for Applications 
  With Worksheets(1).PivotTables("Pivot1")
    .ErrorString = "-"
    .DisplayErrorString = True
End With

See Also