PivotTable.DisplayNullString Property
Excel Developer Reference |
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.
Visual Basic for Applications |
---|
|
This example causes the PivotTable report to display 0 (zero) in cells that contain null values.
Visual Basic for Applications |
---|
|
See Also