I am looking for a macro that copies a specific range of cells from one workbook to a new workbook. The macro would copy cells A1:HC5
from "Workbook1"
, and paste into the same cells (A1:HC5)
of "Workbook2"
.
Thanks for any guidance!
I am looking for a macro that copies a specific range of cells from one workbook to a new workbook. The macro would copy cells A1:HC5
from "Workbook1"
, and paste into the same cells (A1:HC5)
of "Workbook2"
.
Thanks for any guidance!
This should work:
Sub test()
Dim wbk As Workbook
strFirstFile = "C:source.xls"
strSecondFile = "C:destination.xls"
Range("A1:HC35").Copy
Set wbk = Workbooks.Open(strSecondFile)
With wbk.Sheets("Sheet1")
Range("A1").PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
End With
End Sub