Tutorial by Examples

Dim lo as ListObject Dim MyRange as Range Set lo = Sheet1.ListObjects(1) 'or Set lo = Sheet1.ListObjects("Table1") 'or Set lo = MyRange.ListObject

Dim lo as ListObject Dim lr as ListRow Dim lc as ListColumn Set lr = lo.ListRows.Add Set lr = lo.ListRows(5) For Each lr in lo.ListRows lr.Range.ClearContents lr.Range(1, lo.ListColumns("Some Column").Index).Value = 8 Next Set lc = lo.ListColumns.Add Set lc = lo.Lis...

Dim lo as ListObject Set lo = Sheet1.ListObjects("Table1") lo.Unlist