Thread: Need Help with Code for Copy and Pasting between Workbooks
View Single Post
 
Old 03-10-2016, 06:12 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
Just specify the workbooks:

Code:
Workbooks("Test.xls").Sheets("Sheet1").Range("C6,C10,C14,C18,C22,C26,C30,C34,C38,C42,C46,C50").Copy Destination:=Workbooks("Template.xlsm").Sheets("Sheet1").Range("B6")
for example.
Reply With Quote