Skip to main content

XlLocationInTable enumeration

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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>