Export (0) Print
Expand All
Expand Minimize

XlLocationInTable Enumeration

Specifies the part of the PivotTable report that contains the upper-left corner of a range.

Version Added: Excel 2007

Name

Value

Description

xlColumnHeader

-4110

Column header

xlColumnItem

5

Column item

xlDataHeader

3

Data header

xlDataItem

7

Data item

xlPageHeader

2

Page header

xlPageItem

6

Page item

xlRowHeader

-4153

Row header

xlRowItem

4

Row item

xlTableBody

8

Table body

Show:
© 2014 Microsoft