Workbooks("SrcWB").Worksheets(SrcWS").range(A1).Co py _
Workbooks("DestWB").Worksheets(DestWS").range(b2)

HTH
--
AP

"vbidiot" a écrit
dans le message de
...

i'm copying data from 1 sheet and pasting to another workbook.


--
vbidiot
------------------------------------------------------------------------
vbidiot's Profile:
http://www.excelforum.com/member.php...o&userid=31582
View this thread: http://www.excelforum.com/showthread...hreadid=518988