help needed with copy from one workbook to another
I am trying to copy things without using Windows("name").Activate
Workbooks(Orig_NameWB).Worksheets(Orig_NameWS).Ran ge(Cells(Line_No,
1), Cells(Line_No, 6)).Copy _
Destination:=Workbooks(New_NameWB).Worksheets(New_ NameWS).Range(Cells(New_Line_No,
1), Cells(New_Line_No, 6))
But this gives an error 1004 and I do not see what I am doing wrong
|