PivotTable.DisplayNullString (Excel)

True if the PivotTable report displays a custom string in cells that contain null values. The default value is True.

Use the NullString property to set the custom null string.

ActiveCell.PivotTable.DisplayNullString = True