Skip to main content
Row

TableColumn Members

A single column in a table.

Properties

Name Description
ArrayFormula Gets or sets the array formula applied to all cells in the table column.
DataRange Returns the cell range that contains column data (without the column header and total cell).
Formula Gets or sets the formula applied to all cells in the table column.
Index Get the zero-based index of the column within the table’s TableColumnCollection.
Name Gets or sets the name of the table column.
Range Returns the cell range that contains the entire table column.
Total Returns the cell that contains the column total.
TotalRowArrayFormula Specifies an array formula to calculate the column total.
TotalRowFormula Specifies a formula to calculate the column total.
TotalRowFunction Specifies a predefined function to calculate the column total.
TotalRowLabel Specifies text displayed in the total cell of the table column.

Methods

Name Description
Delete() Deletes a column from a table.
See Also