This documentation is archived and is not being maintained.

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

Dim range1 As Range

Dim returnValue As XlLocationInTable
returnValue = range1.LocationInTable

XlLocationInTable LocationInTable {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