Share via

ListObject Object Members

  • Article
Excel Developer Reference

Represents a table on a worksheet.

Methods

  Name Description
Bb242354.methods(en-us,office.12).gif Delete Deletes the ListObject object and clears the cell data from the worksheet.
Bb242354.methods(en-us,office.12).gif ExportToVisio Exports a ListObject object to Visio.
Bb242354.methods(en-us,office.12).gif Publish Publishes the ListObject object to a server that is running Microsoft Windows SharePoint Services.
Bb242354.methods(en-us,office.12).gif Refresh Retrieves the current data and schema for the list from the server that is running Microsoft Windows SharePoint Services. This method can be used only with lists that are linked to a SharePoint site. If the SharePoint site is not available, calling this method will return an error.
Bb242354.methods(en-us,office.12).gif Resize The Resize method allows a ListObject object to be resized over a new range. No cells are inserted or moved.
Bb242354.methods(en-us,office.12).gif Unlink Removes the link to a Microsoft Windows SharePoint Services site from a list. Returns Nothing.
Bb242354.methods(en-us,office.12).gif Unlist Removes the list functionality from a ListObject object. After you use this method, the range of cells that made up the the list will be a regular range of data.

Properties

  Name Description
Bb242354.properties(en-us,office.12).gif 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. Read-only Boolean.
Bb242354.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb242354.properties(en-us,office.12).gif AutoFilter Filters a list using the AutoFilter. Read-only.
Bb242354.properties(en-us,office.12).gif Comment Returns or sets the comment associated with the list object. Read/write String.
Bb242354.properties(en-us,office.12).gif Creator Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
Bb242354.properties(en-us,office.12).gif DataBodyRange Returns a Range object that represents the range of values, excluding the header row, in a table. Read-only.
Bb242354.properties(en-us,office.12).gif DisplayName Returns or sets the display name for the specified ListObject object. Read/write String.
Bb242354.properties(en-us,office.12).gif DisplayRightToLeft True if the specified ListObject is displayed from right to left instead of from left to right. False if the object is displayed from left to right. Read-only Boolean.
Bb242354.properties(en-us,office.12).gif HeaderRowRange Returns a Range object that represents the range of the header row for a list. Read-only Range.
Bb242354.properties(en-us,office.12).gif InsertRowRange Returns a Range object representing the Insert row, if any, of a specified ListObject object. Read-only Range.
Bb242354.properties(en-us,office.12).gif ListColumns Returns a ListColumns collection that represents all the columns in a ListObject object. Read-only.
Bb242354.properties(en-us,office.12).gif ListRows Returns a ListRows object that represents all the rows of data in the ListObject object. Read-only.
Bb242354.properties(en-us,office.12).gif Name Returns or sets a String value that represents the name of the ListObject object.
Bb242354.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb242354.properties(en-us,office.12).gif QueryTable Returns the QueryTable object that provides a link for the ListObject object to the list server. Read-only.
Bb242354.properties(en-us,office.12).gif Range Returns a Range object that represents the range to which the specified list object in the above list applies.
Bb242354.properties(en-us,office.12).gif SharePointURL Returns a String representing the URL of the SharePoint list for a given ListObject object. Read-only String.
Bb242354.properties(en-us,office.12).gif ShowAutoFilter Returns Boolean to indicate whether the AutoFilter will be displayed. Read/write Boolean.
Bb242354.properties(en-us,office.12).gif ShowHeaders Returns or sets if the header information should be displayed for the specified ListObject object. Read/write Boolean.
Bb242354.properties(en-us,office.12).gif ShowTableStyleColumnStripes Returns or sets if the Column Stripes table style is used for the specified ListObject object. Read/write Boolean.
Bb242354.properties(en-us,office.12).gif ShowTableStyleFirstColumn Returns or sets if the first column is formatted for the specified ListObject object. Read/write Boolean.
Bb242354.properties(en-us,office.12).gif ShowTableStyleLastColumn Returns or sets if the last column is displayed for the specified ListObject object. Read/write Boolean.
Bb242354.properties(en-us,office.12).gif ShowTableStyleRowStripes Returns or sets if the Row Stripes table style is used for the specified ListObject object. Read/write Boolean.
Bb242354.properties(en-us,office.12).gif ShowTotals Gets or sets a Boolean to indicate whether the Total row is visible. Read/write Boolean.
Bb242354.properties(en-us,office.12).gif Sort Gets or sets the sort column or columns, and sort order for the ListObject collection.
Bb242354.properties(en-us,office.12).gif SourceType Returns a XlListObjectSourceType value that represents the current source of the list.
Bb242354.properties(en-us,office.12).gif TableStyle Gets or sets the table style for the specified ListObject object. Read/write Variant.
Bb242354.properties(en-us,office.12).gif TotalsRowRange Returns a Range representing the Total row, if any, from a specified ListObject object. Read-only.
Bb242354.properties(en-us,office.12).gif XmlMap Returns an XmlMap object that represents the schema map used for the specified table. Read-only.