| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy COLUMN from 1 worksheet to another (in a different workbook) | Excel Discussion (Misc queries) | |||
| copy a workbook from other workbook with lot of sheets wit... | Excel Discussion (Misc queries) | |||
| How can I save an editable copy of a protected excel workbook? | Excel Discussion (Misc queries) | |||
| Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
| copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
Threaded Mode
