This documentation is archived and is not being maintained.

ListObject Object [Excel 2003 VBA Language Reference]

Office 2003
Multiple objects
ListObject
Multiple objects

Represents a list object on a worksheet. The ListObject object is a member of the

Visit

collection. The ListObjects collection contains all the list objects on a worksheet.

Using the ListObject Object

Use the ListObjects property of the

Visit

object to return a ListObjects collection. The following example adds a new

Visit

object to the default ListObject object in the first worksheet of the active workbook.

   Dim wrksht As Worksheet
   Dim oListCol As ListRow
   
   Set wrksht = ActiveWorkbook.Worksheets("Sheet1")
   Set oListCol = wrksht.ListObjects(1).ListRows.Add


Methods | Delete Method | Publish Method | Refresh Method | Resize Method | Unlink Method | Unlist Method | UpdateChanges Method



Show: