Range.Column property (Excel)

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


expression. Column

expression A variable that represents a Range object.


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.



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

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

Sample code provided by: Dennis Wallentin, VSTO & .NET & Excel

This example deletes the empty columns from a selected range.

Sub Delete_Empty_Columns()
    'The range from which to delete the columns.
    Dim rnSelection As Range
    'Column and count variables used in the deletion process.
    Dim lnLastColumn As Long
    Dim lnColumnCount As Long
    Dim lnDeletedColumns As Long
    lnDeletedColumns = 0
    'Confirm that a range is selected, and that the range is contiguous.
    If TypeName(Selection) = "Range" Then
        If Selection.Areas.Count = 1 Then
            'Initialize the range to what the user has selected, and initialize the count for the upcoming FOR loop.
            Set rnSelection = Application.Selection
            lnLastColumn = rnSelection.Columns.Count
            'Start at the far-right column and work left: if the column is empty then
            'delete the column and increment the deleted column count.
            For lnColumnCount = lnLastColumn To 1 Step -1
                If Application.CountA(rnSelection.Columns(lnColumnCount)) = 0 Then
                    lnDeletedColumns = lnDeletedColumns + 1
                End If
            Next lnColumnCount
            rnSelection.Resize(lnLastColumn - lnDeletedColumns).Select
            MsgBox "Please select only one area.", vbInformation
        End If
        MsgBox "Please select a range.", vbInformation
    End If
    'Turn screen updating back on.
    Application.ScreenUpdating = True

End Sub

About the contributor

Dennis Wallentin is the author of VSTO & .NET & Excel, a blog that focuses on .NET Framework solutions for Excel and Excel Services. Dennis has been developing Excel solutions for over 20 years and is also the coauthor of "Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA and .NET (2nd Edition)."

See also

Range Object