Thread: Pasting into a row specified by a value in a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
The Grinch[_14_] The Grinch[_14_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote