Excel.PivotTable.RowGrand.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotTable.RowGrand property (Excel)	vbaxl10.chm235094	vbaxl10.chm235094	Excel.PivotTable.RowGrand	9d016b8d-4c2b-86a3-bcf1-a9a7356b825d	05/09/2019	medium

PivotTable.RowGrand property (Excel)

True if the PivotTable report shows grand totals for rows. Read/write Boolean.

Syntax

expression.RowGrand

expression A variable that represents a PivotTable object.

Example

This example sets the PivotTable report to show grand totals for rows.

Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable 
pvtTable.RowGrand = True

[!includeSupport and feedback]