Sets a PivotTable report to one of the predefined indented, nonindented, or cross-tabulated formats.
Syntax
expression.Format(Type)
expression An expression that returns a PivotTable object.
Type Required XlPivotFormatType. Specifies the type of report formatting to be applied to the specified PivotTable report. Can be one of the following XlPivotFormatType constants: xlPTClassic, xlPTNone, xlReport1, xlReport2, xlReport3, xlReport4, xlReport5, xlReport6, xlReport7, xlReport8, xlReport9, xlReport10, xlTable1, xlTable2, xlTable3, xlTable4, xlTable5, xlTable6, xlTable7, xlTable8, xlTable9, xlTable10.