XlLocationInTable Enumeration

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

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