Need Help with Code for Copy and Pasting between Workbooks

rsrasc · #1 03-09-2016, 01:23 PM

Hi all,

I'm wondering if the below code can be re-written. I'm trying to copy and paste a range (multiple cells) from a workbook ("Text") to another workbook called "Template" but does not work for me and I can't figure it out.

Code:

Sub Macro5()
'
' Macro2 Macro
'

'
    Windows("Test.xls").Activate
    Range("A12:I12").Select
    Selection.Copy
    Windows("Template.xlsm").Activate
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Range("C6").Select
End Sub

The purpose of my question is that I would like to copy multiple cells with the above "re-written" code or a new code so I can copy multiple cells like I did with the below code. The code shown below worked for me when copying and pasting from one sheet to another sheet in the same workbook.

Code:

Sheets("Interface").Range("C6,C10,C14,C18,C22,C26,C30,C34,C38,C42,C46,C50").Copy Destination:=Sheets("MyData").Range("B6")

Any help is appreciated.

Thanks,
Cheers!

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