Excel.PivotTable.NullString.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotTable.NullString property (Excel)	vbaxl10.chm235114	vbaxl10.chm235114	Excel.PivotTable.NullString	f9d678d1-5e9f-8d3b-1f9a-73e8679ae499	05/09/2019	medium

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.

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.

With Worksheets(1).PivotTables("Pivot1") 
 .NullString = "NA" 
 .DisplayNullString = True 
End With

[!includeSupport and feedback]