LocationInTable Property
Collapse the table of content
Expand the table of content
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

Range.LocationInTable Property 

Returns a constant that describes the part of the PivotTable report that contains the upper-left corner of the specified range.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

Dim range1 As Range

Dim returnValue As XlLocationInTable
returnValue = range1.LocationInTable

property XlLocationInTable^ LocationInTable{
	XlLocationInTable^ get();
public XlLocationInTable get_LocationInTable();
function get LocationInTable() : XlLocationInTable;

XlLocationInTable can be one of the following XlLocationInTable constants:

  • xlRowHeader

  • xlColumnHeader

  • xlPageHeader

  • xlDataHeader

  • xlRowItem

  • xlColumnItem

  • xlPageItem

  • xlDataItem

  • xlTableBody

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

© 2016 Microsoft