Export (0) Print
Expand All
Expand Minimize

Range.Column Property

Office 2007
Returns the number of the first column in the first area in the specified range. Read-only Long.

Syntax

expression.Column

expression   A variable that represents a Range object.

Remarks

Column A returns 1, column B returns 2, and so on.

To return the number of the last column in the range, use the following expression.

myRange.Columns(myRange.Columns.Count).Column

Example

This example sets the column width of every other column on Sheet1 to 4 points.

Visual Basic for Applications
For Each col In Worksheets("Sheet1").Columns
    If col.Column Mod 2 = 0 Then
        col.ColumnWidth = 4
    End If
Next col



Community Additions

ADD
Show:
© 2014 Microsoft