If you look at the Object Model you'll see that Workbook is a
collection. Any open workbook should be part of that collection. So, if
you only have these 2 books open you should be able to switch from
workbook(1) to workbook(20, using the sheets collection, and the cells
collection, ranges, etc to grab the data from one book and copy or move
this to the other.

E.g.

Workbooks(1).Sheets("Sheet1).Range("A1:C50").copy
Workbooks(2).Sheets("Sheet1)Range("A1").Paste

Something like that from memory anyway. use VBA Help for the workbooks
collection and you'll get the general idea.

HTH

Art


--
HiArt
------------------------------------------------------------------------
HiArt's Profile: http://www.excelforum.com/member.php...o&userid=19953
View this thread: http://www.excelforum.com/showthread...hreadid=345847