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/