EXCEL MACRO two active cells and their rows

[alrodopial]

I have selected two cells in a sheet that are not consecutive ie A4 and C12

How do I get their rows number in two variables? VBA
ie MyRow1 = 4, MyRow2 = 12

[osknows]

This is one way of doing it

Code: Select all

Sub selectedCells()
Dim MyRow1 As Long
Dim MyRow2 As Long
Dim MyAddress() As String

    With Selection
        If .Count = 2 Then
            MyAddress = Split(.Address, ",")
            MyRow1 = Split(MyAddress(0), "$")(2)
            MyRow2 = Split(MyAddress(1), "$")(2)
        End If
    End With
End Sub

[alrodopial]

So with Selection.Address you get ie $A$4 as string and then extract the 4
Thanks os