I didn't exatly follow your logic but to paste a cell I use


activecell.value=sheets("Sheet 4").cells(rr+2,cc+1)

This assumes the data is in a common workbook otherwise ...

activecell.value=workbooks("book2.xls").sheets("Sh ee
4").cells(rr+2,cc+1)

Hope this help

--
jmoffa
-----------------------------------------------------------------------
jmoffat's Profile: http://www.excelforum.com/member.php...nfo&userid=115
View this thread: http://www.excelforum.com/showthread.php?threadid=27011