Column::DisplayPosition property

The DisplayPosition property sets or returns the order of the column in the set of columns. The order is 1-based (the first column is at position 1). This property is read/write.

Syntax

Property DisplayPosition As Long

Property value

An index of the column in its position among the set of columns.

Remarks

Setting the DisplayPosition property is consistent with a user dragging a column header to another position, or moving a column up or down in the Add/Remove Columns dialog box. The first column can be moved to any other position, and any other column can be moved to the first position.

Examples

' Retrieve the column's display position.
Dim nPos As Long
nPos = objCol.DisplayPosition
 
' Assign this column to the third position.
objCol.DisplayPosition = 3

Requirements

See also

Column.Name

Column.IsSortColumn