get row number in excel macros

how do i get the row number of the active cell? i am trying to write a macro and i can't figure it out.

thank you
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

jmfairchildConnect With a Mentor Commented:
I'm not an Excel expert, but I believe what you are looking for is:

Formula in active cell:


Macro to get Active cell:

Current_Row = ActiveCell.Row

CharlesBronsonAuthor Commented:
you're right. i woke up this morning and it suddenly came to my mind. thanks for your cooperation!
All Courses

From novice to tech pro — start learning today.