that seems to be the same as:Sub LastOne() Dim Last As Range Set Last = [A1].SpecialCells(xlCellTypeLastCell) MsgBox "Column " & Last.Column & " is the last column" '< msgbox example Columns(Last.Column).Select '< select example End Sub
ActiveSheet.UsedRange.Rows.Count