bernardoafs,

How do I get control back to my destination workbook so I can paste the
second time? I tried entering the following line:

Windows(ThisWorkbook.Path & "\destination file.xls").Activate

But I get a subscript out of range error...


--
mwc0914
------------------------------------------------------------------------
mwc0914's Profile: http://www.excelforum.com/member.php...o&userid=24130
View this thread: http://www.excelforum.com/showthread...hreadid=487404