ColumnIndex Property
Applies To
Cell object.
Description
Returns the number of the table column that contains the specified cell. Read-only Long.
See Also
Columns property, IsFirst property, IsLast property, Item method, RowIndex property.
Example
This example creates a table in a new document, selects each cell in the first row, and returns the column number that contains the selected cell.
Set newDoc = Documents.Add
Set myTable = newDoc.Tables.Add(Selection.Range, 3, 3)
For Each aCell In myTable.Rows(1).Cells
aCell.Select
MsgBox "This is column " & aCell.ColumnIndex
Next aCell
This example returns the column number of the cell that contains the insertion point.
Msgbox Selection.Cells(1).ColumnIndex