Expand Minimize
This topic has not yet been rated - Rate this topic

PivotTable.NullString Property (Excel)

Returns or sets the string displayed in cells that contain null values when the DisplayNullString property is True. The default value is an empty string (""). Read/write String.

expression .NullString

expression A variable that represents a PivotTable object.

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.