DisplayNullString Property

Applies To

PivotTable object.

Description

True if the PivotTable displays a custom string in cells that contain null values. The default value is True. Read/write Boolean.

Remarks

Use the NullString property to set the custom null string.

See Also

DisplayErrorString property, NullString property.

Example

This example causes the PivotTable to display "NA" in cells that contain null values.

With Worksheets(1).PivotTables("Pivot1")
    .NullString = "NA"
    .DisplayNullString = True
End With

This example causes the PivotTable to display 0 (zero) in cells that contain null values.

Worksheets(1).PivotTables("Pivot1").DisplayNullString = False