VBA: Get the active cell’s Row

August 14th, 2004 | Categories: Cells, Columns & Rows | Tags: , ,
-->

If you need to get the active cell’s row from VBA, this should do it!

Put this in a module:

Sub MyActiveRow()

MsgBox Activecell.Row

End Sub
Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Leave a comment | Trackback
  1. Rico
    May 19th, 2011 at 08:10
    Reply | Quote | #1

    Hello!

    What if i need the row value of the active cell? Any sugestions?

    Regards,

  2. Cuong
    July 29th, 2011 at 04:08
    Reply | Quote | #2

    Thanks very much, I need it. i have been finding for half an day