ListFormulas Method

Microsoft Excel Visual Basic

Show All

ListFormulas Method

       

Creates a list of calculated PivotTable items and fields on a separate worksheet.

expression.ListFormulas

expression   Required. An expression that returns a PivotTable object.

Remarks

This method isn’t available for OLAP data sources.

Example

This example creates a list of calculated items and fields for the first PivotTable report on worksheet one.

Worksheets(1).PivotTables(1).ListFormulas