Select first cell of a range

Hi Scott

Thanks for your question, and first let me apologise for the delay in responding.

The following code will carry out the action you require. it assigns the first cell of the selected range to a range variable and then displays that cell's address in a message box

Dim rngMyRange As Range

    

    

    Set rngMyRange = Selection

    

    MsgBox rngMyRange.Cells(1, 1).Address