Format Method

Microsoft Excel Visual Basic

Format Method

       

Sets a PivotTable report to one of the predefined indented, nonindented, or cross-tabulated formats.

expression.Format(Format)

expression   Required. An expression that returns one of the objects in the Applies To list.

Format  Required XlPivotFormatType.  Specifies the type of report formatting to be applied to the specified PivotTable report.

XlPivotFormatType can be one of these XlPivotFormatType constants.
xlPTClassic
xlPTNone
xlReport1
xlReport10
xlReport2
xlReport3
xlReport4
xlReport5
xlReport6
xlReport7
xlReport8
xlReport9
xlTable1
xlTable10
xlTable2
xlTable3
xlTable4
xlTable5
xlTable6
xlTable7
xlTable8
xlTable9

Example

This example applies the xlReport4 indented format to the fourth PivotTable report on the active worksheet.

ActiveSheet.PivotTables("PivotTable4").Format xlReport4