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

FAQ

Mark Forums Read

Thread Tools

Display Modes

03-10-2016, 06:12 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

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.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 01:25 AM.