expression.DisplayEmptyRow
expression Required. An expression that returns a PivotTable object.
Remarks
The PivotTable must be connected to an Online Analytical Processing (OLAP) data source to avoid a run-time error.
Example
This example determines the display settings for empty rows in a PivotTable. It assumes a PivotTable connected to an OLAP data source exists on the active worksheet.
Sub CheckSetting()
Dim pvtTable As PivotTable
Set pvtTable = ActiveSheet.PivotTables(1)
' Determine display setting for empty rows.
If pvtTable.DisplayEmptyRow = False Then
MsgBox "Empty rows will not be displayed."
Else
MsgBox "Empty rows will be displayed."
End If
End Sub