Tandaan
Ang pag-access sa pahinang ito ay nangangailangan ng pahintulot. Maaari mong subukang mag-sign in o baguhin ang mga direktoryo.
Ang pag-access sa pahinang ito ay nangangailangan ng pahintulot. Maaari mong subukang baguhin ang mga direktoryo.
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.