Class ListColumn (Excel VBA)
The class ListColumn represents a column in a table.
Member in collection
To use a ListColumn class variable it first needs to be instantiated, for example
Dim lstcol as ListColumn Set lstcol = ActiveCell.ListObject.ListColumns(Index:=1)
Here is an example of processing the ListColumn items in a collection.
Dim lstcol As ListColumn For Each lstcol In ActiveCell.ListObject.ListColumns Next lstcol
Delete - Deletes the column of data in the list.
ListColumns.Add - Adds a new column to the list object.
DataBodyRange returns a Range object that is the size of the data portion of a column.
Index returns a Long value that represents the index number of the ListColumn object within the ListColumns collection.
Range returns a Range object that represents the range to which the specified list object applies.
Total returns the Total row for a ListColumn object.
TotalsCalculation determines the type of calculation in the Totals row of the list column based on the value of the XlTotalsCalculation enumeration.
XPath returns an XPath object that represents the XPath of the element mapped to the specified Range object. The context of the range determines whether the action succeeds or returns an empty object.
ListColumns.Count returns an Integer value that represents the number of objects in the collection.
Range - Represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3D range.
XPath - Represents an XPath that has been mapped to a Range or ListColumn object.