ListObject Object [Excel 2003 VBA Language Reference]
Multiple objects ListObject Multiple objects |
Represents a list object on a worksheet. The ListObject object is a member of the
Visit ListObjects
collection. The ListObjects collection contains all the list objects on a worksheet.
Using the ListObject Object
Use the ListObjects property of the
Visit Worksheet
object to return a ListObjects collection. The following example adds a new
Visit ListRow
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
Properties | Active Property | Application Property | Creator Property | DataBodyRange Property | DisplayRightToLeft Property | HeaderRowRange Property | InsertRowRange Property | ListColumns Property | ListRows Property | Name Property | Parent Property | QueryTable Property | Range Property | SharePointURL Property | ShowAutoFilter Property | ShowTotals Property | SourceType Property | TotalsRowRange Property | XmlMap Property
Methods | Delete Method | Publish Method | Refresh Method | Resize Method | Unlink Method | Unlist Method | UpdateChanges Method
Parent Objects | ListObjects Collection | QueryTable Object | Range Collection
Child Objects | ListColumns Object | ListRows Object | QueryTable Object | Range Object | XmlMap Object
See Also | ListColumn Object | ListRow Object