PivotTable.NullString (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 ("").

ActiveCell.PivotTable.NullString = "NA"