Do you mean this Steve

Sub test()
Dim RW As Long
RW = ActiveCell.Row

MsgBox RW
End Sub


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Steve R" wrote in message ...
I need to store the row number in a variable.
Does anyone know how to capture just the row number (where
my cursor resides) in an Excel spreadsheet.