Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

ListColumns Collection [Excel 2003 VBA Language Reference]

Office 2003
Multiple objects

A collection of all the ListColumn objects in the specified


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.

Methods | Add Method

Parent Objects | ListObject

Child Objects | ListDataFormat | Range | XPath

© 2015 Microsoft