Application.FilterShowSummaryRows method (Project)

Shows or hides the related summary rows.


expression. FilterShowSummaryRows( _On_ )

expression An expression that returns an Application object.


Name Required/Optional Data type Description
On Required Boolean True if summary rows are shown; otherwise, False.

Return value



The FilterShowSummaryRows method corresponds to the following command on the ribbon: on the View tab, click the Filter drop-down list box in the Data section, and then click Show Related Summary Rows.


If the current filter shows only completed tasks, for example, the following command shows the summary tasks.

FilterShowSummaryRows (true)

Support and feedback

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.