xlPivotFormatType

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

xlPTClassic20
xlPTNone21
xlReport10
xlReport109
xlReport21
xlReport32
xlReport43
xlReport54
xlReport65
xlReport76
xlReport87
xlReport98
xlTable110
xlTable1019
xlTable211
xlTable312
xlTable413
xlTable514
xlTable615
xlTable716
xlTable817
xlTable918

xlPTClassic
20
xlPTNone
21
xlReport1
0
xlReport10
9
xlReport2
1
xlReport3
2
xlReport4
3
xlReport5
4
xlReport6
5
xlReport7
6
xlReport8
7
xlReport9
8
xlTable1
10
xlTable10
19
xlTable2
11
xlTable3
12
xlTable4
13
xlTable5
14
xlTable6
15
xlTable7
16
xlTable8
17
xlTable9
18

REMARKS
* Added in 2000.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top