VBA question - Copying Sheet from Workbook to another
 

Plz,

Which instruction I use to copy SheetX from Workbook A to Workbook B?

Thank

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

VBA question - Copying Sheet from Workbook to another
 

Try something like


Workbooks("BookA.xls").Worksheets("Sheet1").Copy _
after:=Workbooks("BookB.xls").Worksheets("Sheet1")



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"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/

VBA question - Copying Sheet from Workbook to another
 

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/