Plz, Which instruction I use to copy SheetX from Workbook A to Workbook B? Thank
A ajliaks Apr 14, 2004 #1 Plz, Which instruction I use to copy SheetX from Workbook A to Workbook B? Thank
C Chip Pearson Apr 14, 2004 #2 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
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
B Bob Phillips Apr 14, 2004 #3 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)
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)
