VBA command to get row

[mrpman97]

After selecting a cell, what is the command to get the row number of that cell in VBA?

 

[Armando Montes]

Something like this:

Sub Foo()
x = ActiveCell.Row
MsgBox x
End Sub

 

[pedie]

msgbox activecell.row