hit the button too soon. try
Sub test()
ActiveSheet.Next.Range("h3") = ActiveCell.Row
End Sub


--
Don Guillett
SalesAid Software

"leonidas" wrote in
message ...

Hi,

I have the following macro. How do I paste the rownumber in cell H32?

Sub test()

myrow = ActiveCell.Row
ActiveSheet.Next.Select
Range("H32").Select

End Sub


--
leonidas
------------------------------------------------------------------------
leonidas's Profile:
http://www.excelforum.com/member.php...o&userid=35375
View this thread: http://www.excelforum.com/showthread...hreadid=556426