WorkSheets("Sheet1").Copy
After:=Workbooks("Book1").Worksheets(Workbooks("Bo ok1").Worksheets.Count)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"ajliaks " wrote in message
...
Plz,
Which instruction I use to copy SheetX from Workbook A to Workbook B?
Thanks
---
Message posted from http://www.ExcelForum.com/