PivotTable.DisplayNullString Property (Excel)
True if the PivotTable report displays a custom string in cells that contain null values. The default value is True. Read/write Boolean.
Syntax
expression .DisplayNullString
expression A variable that represents a PivotTable object.
Remarks
Use the NullString property to set the custom null string.
Example
This example causes the PivotTable report 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 report to display 0 (zero) in cells that contain null values.
Worksheets(1).PivotTables("Pivot1").DisplayNullString = False