PivotTable.RowGrand property (Excel)
True if the PivotTable report shows grand totals for rows. Read/write Boolean.
expression.RowGrand
expression A variable that represents a PivotTable object.
This example sets the PivotTable report to show grand totals for rows.
VB
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
pvtTable.RowGrand = True
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.