Get Position of Last Column Containing Data with Excel VBA

If you read my latest update on how we can get position of last row containing data, then most probably you already have a glimpse on how we perform the same task with last column containing data in Excel.

The VBA code is the exact replica of the code to get the last row, only this time, we change the row into column.

Function LastColumn() As Long

    Dim ix As Long
    ix = ActiveSheet.UsedRange.Column - 1 + ActiveSheet.UsedRange.Columns.Count
    LastColumn = ix

End Function

The function above will return the appropriate position of the column even when the last column containing data in a hidden state.

The results of this function is the column number, not the column name (1 for A, 2 for B, etc). If what we need is the column name, then we can use the excel column number to column name converter that I wrote before.

Posts Related to Get Position of Last Column Containing Data with Excel VBA

Convert Excel Column Number into Column Name
Update: Sorter version of the VBA function: Function Number2Char(c As Integer) As String Number2Char = Split(Cells(1, c).Address, "$")(1) End Function Courtesy of The Plaid Cow. ...
How To Find the Last Row That Contain Data in Excel?
UPDATE June 13, 2008: Another alternative way to find the last row with data : Function LastRow() As Long Dim ix As Long ix = ...
Finding Cell with Minimum/Maximum Value in Active Worksheet
Let say we want to find position of cell containing the minimum/maximum value in current/active Excel worksheet, and then after we found the cell, we ...
Move Cursor To One Cell Below Last Row With Data
Ever want to paste some data into new empty cell after the last cell with data in certain column? Then take a look at this ...
Auto Expanding VLOOKUP Table Array
Ok, this time I want to talk about how to create a vlookup table array that automatically expanding in accordance with the numbers of available ...

Get Position of Last Column Containing Data with Excel VBA

Posts Related to Get Position of Last Column Containing Data with Excel VBA

Convert Excel Column Number into Column Name

How To Find the Last Row That Contain Data in Excel?

Finding Cell with Minimum/Maximum Value in Active Worksheet

Move Cursor To One Cell Below Last Row With Data

Auto Expanding VLOOKUP Table Array

1,147 Responses to Get Position of Last Column Containing Data with Excel VBA

Leave a Reply Cancel reply

Recent Posts