Hi Bob,

If I understand correctly
ActiveCell.Row
should do the job ...
Now if you need to store it, you would need to have a variable
Dim MyRow As Integer
and place following line in the right spot in your code
MyRow = ActiveCell.Row

HTH
Cheers
Carim