Export (0) Print
Expand All

ListObject Properties 

  Name Description
_Default  
Active Returns a Boolean value indicating whether a ListObject object in a worksheet is active — that is, whether the active cell is inside the range of the ListObject object.
Application Returns an Application object that represents the Microsoft Excel application.
Creator Returns a 32-bit integer that indicates the application in which this object was created.
DataBodyRange Returns a Range object that represents the range that contains the data area in the list between the header row and the insert row.
DisplayRightToLeft Determines if the specified window, worksheet, or ListObject object is displayed from right to left instead of from left to right.
HeaderRowRange Returns a Range object that represents the range of the header row for a list.
InsertRowRange Returns a Range object representing the Insert row, if any, of a specified ListObject object.
ListColumns Returns a ListColumns collection that represents all the columns in a ListObject object.
ListRows Returns a ListRows object that represents all the rows of data in the ListObject object.
Name Returns or sets the name of the ListObject object.
Parent Returns the parent object for the specified object.
QueryTable Returns the QueryTable object that provides a link for the ListObject object to the list server.
Range Returns a Range object that represents the range to which the specified list object applies.
SharePointURL Returns a String representing the URL of the SharePoint list for a given ListObject object.
ShowAutoFilter Returns a Boolean value indicating whether the AutoFilter will be displayed.
ShowTotals Returns or sets a Boolean value to indicate whether the Total row is visible.
SourceType Returns one of the XlListObjectSourceType constants indicating the current source of the list.
TotalsRowRange Returns a Range object representing the Total row, if any, from a specified ListObject object.
XmlMap Returns an XmlMap object that represents the schema map used for the specified list.

Community Additions

ADD
Show:
© 2014 Microsoft