Not
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.