DisplayNullString Property 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