The sheet already exists in both workbooks?
Dim rng1 as Range, rng2 as Range
set rng1 = workbooks("book1.xls").worksheets(1).Cells
set rng2 = workbooks("Book2.xls").worksheets(1).Cells
rng1.copy Destination:=rng2

--
Regards,
Tom Ogilvy

"Jonx " wrote in message
...
Hello, I was curious if I have two workbooks, and I would like to copy
worksheet 1 from book 1 to worksheet 1 on book 2, how would I go about
doing this? How would I execute this code in VB?

thanks.


---
Message posted from http://www.ExcelForum.com/