Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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

ReadOnly Property LocationInTable() As XlLocationInTable
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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.