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

Get LIVE Help
Custom Excel solutions & live Excel help!
► Go to www.ExcelAutomationHelp.com
► Email Now@ExcelAutomationHelp.com
  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