Hi
try recording a macro while doing the following manually:
- assumption: both workbooks are opened
- activate the source workbook
- select the tab and right-click on the tab name
- choose Move7Copy
- select the target workbook + location

--
Regards
Frank Kabel
Frankfurt, Germany

"Jonx " schrieb im Newsbeitrag
...
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/