ListColumns Collection [Excel 2003 VBA Language Reference]
ListObject ListColumns ListColumn Multiple objects |
A collection of all the ListColumn objects in the specified
Visit ListObject
object. Each ListColumn object represents a column in the list.
Using the ListColumns Collection
Use the ListColumns property of the ListObject object to return the ListColumns collection. The following example adds a new column to the default ListObject object in the first worksheet of the workbook. Because no position is specified, a new rightmost column is added.
Set myNewColumn = Worksheets(1).ListObject(1).ListColumns.Add
Note A name for the column is automatically generated. You can change the name after the column has been added.
Properties | Application Property | Count Property | Creator Property | Item Property | Parent Property
Methods | Add Method
Parent Objects | ListObject
Child Objects | ListDataFormat | Range | XPath
See Also | ListRows Collection