Format Method [Excel 2003 VBA Language Reference]
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.
XlPivotFormatType
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
Applies to | PivotTable Object