Pasting into a row specified by a value in a cell
 

Thank you rob!

FYI I've devised a simpler solution...

Record the macro using relative references then change the ro
reference to point to a cell value....

ActiveCell.Offset(-Range("b13").Value, -2)

Thanks for your help

--
The Grinc
-----------------------------------------------------------------------
The Grinch's Profile: http://www.excelforum.com/member.php...nfo&userid=244
View this thread: http://www.excelforum.com/showthread.php?threadid=26717