| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Paste not working from Add-in - Error 1004
The below code is in an add-n, when my main workbook had a reference to the
add-in it worked fine. When I removed the reference, and used RUN to call the macro it failed as per below. Any ideas? ThisWorkbook.Names("Data_Main").RefersToRange.Copy Windows(WorkbookMain).Activate Sheets("Data").Select Range("b5").Select ActiveSheet.Paste <--- errors with Error 1004 Paste method of Worksheet class failed. -- Trefor |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error 1004 in search/copy | Excel Programming | |||
| After sharing workbook VB code stops working. Runtime Error 1004 | Excel Programming | |||
| runtime error 1004 paste method of worksheet class failed | Excel Programming | |||
| Run Time error 1004 Paste Method of Worksheet Class Failed | Excel Programming | |||
| Range.Copy and error 1004 | Excel Programming | |||
Threaded Mode
