Share via

ListObject.ListColumns Property (Excel)

  • 아티클

Returns a ListColumns collection that represents all the columns in a ListObject object. Read-only.

Syntax

식 .ListColumns

식 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

참고 항목

개념

ListObject Object Members

ListObject Object