ListColumn object (Excel)

Represents a column in a table.

Remarks

The ListColumn object is a member of the ListColumns collection. The ListColumns collection contains all the columns in a table.

Use the ListColumns property of the ListObject object to return a ListColumns collection.

Example

The following example adds a new ListColumn object to the default ListObject object in the first worksheet of the active workbook. Because no position is specified, a new rightmost column is added.

Sub AddListColumn() 
 Dim wrksht As Worksheet 
 Dim objListCol As ListColumn 
 
 Set wrksht = ActiveWorkbook.Worksheets("Sheet1") 
 Set objListCol = wrksht.ListObjects(1).ListColumns.Add 
End Sub 

Methods

• Delete

Properties

• Application
• Creator
• DataBodyRange
• Index
• Name
• Parent
• Range
• Total
• TotalsCalculation
• XPath

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.