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 |