VBA question - Copying Sheet from Workbook to another

  • Thread starter Thread starter ajliaks
  • Start date Start date
A

ajliaks

Plz,

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

Thank
 
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
 
WorkSheets("Sheet1").Copy
After:=Workbooks("Book1").Worksheets(Workbooks("Book1").Worksheets.Count)


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sheet Order _ Numbering 7
How to append data from different sheet and different workbook? 2
Excel Protection 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Loop within worksheet array 5
Excel Move or Copy Stopped Working? 0
VBA code for pasting links -- modifying RDB code for summary workbook 10
Scattered array cells copy to scattered array cells another workbook 14

Back
Top