expression.DisplayEmptyColumn
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 columns 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 columns.
If pvtTable.DisplayEmptyColumn = False Then
MsgBox "Empty columns will not be displayed."
Else
MsgBox "Empty columns will be displayed."
End If
End Sub