ListObject.ListColumns Property

Syntax

expression.ListColumns

expression A variable that represents a ListObject object.

Example

The following example displays the name of the second column in the ListColumns collection object as created by a call to the ListColumns property. For this code to run, the Sheet1 worksheet must contain a table.

Sub DisplayColumnName Dim wrksht As Worksheet Dim objListObj As ListObject Dim objListCols As ListColumns Set wrksht = ActiveWorkbook.Worksheets("Sheet1") Set objListObj = wrksht.ListObjects(1) Set objListCols = oListObj.ListColumns Debug.Print objListCols(2).Name End Sub 

See also:

• ListObject Object
• ListObject Object Members