Skip to main content

ListColumn object

Table of contents
  1. Remarks
  2. Example

Represents a column in a table.


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.


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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>