TableColumn Properties
A single column in a table.| 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. |
See Also