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
CharlesBronsonAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

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

Formula in active cell:

=row()

Macro to get Active cell:

Current_Row = ActiveCell.Row

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

From novice to tech pro — start learning today.