Siddarth
New Member
Hi all,
I am new to VBA. I want to copy data with in range "A1:E7" to another sheet in a different work book. I have no idea where to start. Can anyone please help?
I have the following code to copy data:
I got no idea how to paste it in the other workbook. The destination file is Test1.xlsx. Please help.
Thanks in advance.
I am new to VBA. I want to copy data with in range "A1:E7" to another sheet in a different work book. I have no idea where to start. Can anyone please help?
I have the following code to copy data:
Code:
Dim wb As Workbook
Set wb = ThisWorkbook
Workbooks.Open Filename:="C:\Users\Siddarth\Desktop\Test 0.xlsm"
Range("A1:E7").Select
Selection.Copy
I got no idea how to paste it in the other workbook. The destination file is Test1.xlsx. Please help.
Thanks in advance.