VBA select Range including a Named Cell

[gtd526]

Hello,
Im using 'mycell' to name the selected cell.
How can I select (A9:mycell) in a range?

Dim mycell As Range
Set mycell = Range("AZ9").End(xlToLeft)
mycell.Select

thank you

 

[Anthony47]

Try

Set mycell = Range(Range("A9"), Selection)

You should also consider using ActiveCell rather then Selection

 

[mumps]

Try:

Sub SelectCell()
    Dim mycell As Range
    Set mycell = Range("AZ9")
    Range("A9:" & mycell.Address).Select
End Sub

 

[gtd526]

Try:

Sub SelectCell()
    Dim mycell As Range
    Set mycell = Range("AZ9")
    Range("A9:" & mycell.Address).Select
End Sub

Thank you.
I modified
Set mycell = Range("AZ9").End(xlToLeft)

 

[mumps]

You are very welcome.