Retreiving the current row number

[Guest]

I'm sure this is dead simple but how can I find out what row I'm on when running a macro.

Cheers

John

 

[Tom Urtis]

Something like this might help.

Sub RowID()
MsgBox ActiveCell.Row
End Sub

Tom Urtis

 

[Guest]

Thanks Tom

Cheers

John