XlLocationInTable enumeration (Excel)
Specifies the part of the PivotTable report that contains the upper-left corner of a range.
| 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 |
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.