Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Format Method [Excel 2003 VBA Language Reference]

Office 2003

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 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


Show: