PivotTable.NullString Property

Syntax

expression.NullString

expression A variable that represents a PivotTable object.

Example

This example causes the PivotTable report to display "NA" in cells that contain null values.

Visual Basic for Applications
`With Worksheets(1).PivotTables("Pivot1") .NullString = "NA" .DisplayNullString = True End With`

create custom null string pivot table NULL NULL String Null String Property NullString nullstring property produce null string pivot table specify null string pivot table

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.

See also: