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: