Thread: Need Help with Code for Copy and Pasting between Workbooks
View Single Post
 
Old 03-10-2016, 08:18 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
It's because you have merged cells (which are the bane of VBA). You need to use:

Code:
Workbooks("PPE.xls").Sheets("Page 1").Range("A12:I12,A16:I16,A20:I20,A24:I24").Copy Destination:=Workbooks("Book2").Sheets("Sheet1").Range("A6")
Note that the Range() property can only take up to 255 characters in the address string.
Reply With Quote