Need Help with Code for Copy and Pasting between Workbooks

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Need Help with Code for Copy and Pasting between Workbooks

03-10-2016, 08:18 AM

Debaser

Windows 7 64bit Need Help with Code for Copy and Pasting between Workbooks

Office 2010 32bit

Competent Performer

Join Date: Oct 2015

Location: UK

Posts: 221

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy + Pasting Excel Tables in word have 8pt spacing	Jiing Chiang	Word Tables	4	01-14-2016 05:43 PM
Copy and pasting problem Word 2010	Sarah262	Word	3	08-16-2012 03:46 PM
Loop through folder of workbooks and copy range to other workbook	Snvlsfoal	Excel Programming	3	07-29-2011 05:55 AM
copy-pasting hyperlinked images: work only at the edges	Xuanzang	PowerPoint	0	12-07-2010 02:35 AM
help Copy from excel and pasting as a metafile in powerpoint	Juiceapple	Office	1	09-15-2009 09:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:03 AM.