ListObject Object Members

Represents a table on a worksheet.

Methods

	Name	Description
	Delete	Deletes the ListObject object and clears the cell data from the worksheet.
	ExportToVisio	The description for this item will appear in the final release of Office.
	Publish	Publishes the ListObject object to a server that is running Microsoft Windows SharePoint Services.
	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.
	Resize	The Resize method allows a ListObject object to be resized over a new range. No cells are inserted or moved.
	Unlink	Removes the link to a Microsoft Windows SharePoint Services site from a list. Returns Nothing.
	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
	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.
	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.
	AutoFilter	Read-only
	Comment	Read/write
	DataBodyRange	Returns a Range object that represents the range of values, excluding the header row, in a table. Read-only.
	DisplayName	Read/write
	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.
	HeaderRowRange	Returns a Range object that represents the range of the header row for a list. Read-only Range.
	InsertRowRange	Returns a Range object representing the Insert row, if any, of a specified ListObject object. Read-only Range.
	ListColumns	Returns a ListColumns collection that represents all the columns in a ListObject object. Read-only.
	ListRows	Returns a ListRows object that represents all the rows of data in the ListObject object. Read-only.
	Name	Returns or sets a String value that represents the name of the ListObject object.
	Parent	Returns the parent object for the specified object. Read-only.
	QueryTable	Returns the QueryTable object that provides a link for the ListObject object to the list server. Read-only.
	Range	Returns a Range object that represents the range to which the specified list object in the above list applies.
	SharePointURL	Returns a String representing the URL of the SharePoint list for a given ListObject object. Read-only String.
	ShowAutoFilter	Returns Boolean to indicate whether the AutoFilter will be displayed. Read/write Boolean.
	ShowHeaders	Read/write
	ShowTableStyleColumnStripes	Read/write
	ShowTableStyleFirstColumn	Read/write
	ShowTableStyleLastColumn	Read/write
	ShowTableStyleRowStripes	Read/write
	ShowTotals	Gets or sets a Boolean to indicate whether the Total row is visible. Read/write Boolean.
	Sort	Read-only
	SourceType	Returns a XlListObjectSourceType value that represents the current source of the list.
	TableStyle	Read/write
	TotalsRowRange	Returns a Range representing the Total row, if any, from a specified ListObject object. Read-only.
	XmlMap	Returns an XmlMap object that represents the schema map used for the specified table. Read-only.