Export (0) Print
Expand All
Expand Minimize

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)

'Usage
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

Community Additions

ADD
Show:
© 2014 Microsoft