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 |