| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
PivotTable.ColumnGrand property (Excel) |
vbaxl10.chm235075 |
|
|
aa012e55-c944-22f1-13da-7ad76ae72c5b |
05/08/2019 |
medium |
True if the PivotTable report shows grand totals for columns. Read/write Boolean.
expression.ColumnGrand
expression A variable that represents a PivotTable object.
This example sets the PivotTable report to show grand totals for columns.
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
pvtTable.ColumnGrand = True[!includeSupport and feedback]