how to call the last column of a range or table

[doriannjeshi]

Hi,
I need to call the last column of a dynamic range , with a macro , and then row 2 of that column needs to referenced

 

[Eric W]

How about:

    Set a = Range("MyRange")
    Debug.Print a.Cells(2, a.Columns.Count)

 

[Skyybot]

Option Explicit

Sub LastColCellTwo()
Dim lCol As Long, myCell As Range

' Find the last Column
lCol = Me.UsedRange.Columns.Count

' Create a reference to row 2 cell of that column

Set myCell = Me.Cells(2, lCol)

End Sub