ListObject Methods (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Name

Description

Delete

Deletes the ListObject object and clears the cell data from the worksheet.

ExportToVisio

Exports a ListObject object to Visio.

Publish

Publishes the ListObject object to a server that is running Microsoft SharePoint Foundation.

Refresh

Retrieves the current data and schema for the list from the server that is running Microsoft SharePoint Foundation. 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 SharePoint Foundation 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.

Show: