Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run time error 1004
When running code that copies one named range from a workbook to a named
range in another workbook I get this run time error saying Select Method of Range Class failed. If i copy the range manually i get the message: "A formula or sheet you want to move or copy contains the name 'WPCodeDescription', which already exists on the destinatin sheet. Do you want to use this version of the name?" Here is the code that causes the error: Workbooks(WkbPrevious).Worksheets(CStr(Cell)).Rang e("WPCodeDescription").Copy Workbooks(wkb).Worksheets(CStr(Cell)).Range("WPCod eDescription").PasteSpecial xlPasteValues thanks for any help, Jake |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run time error 1004 general odbc error excel 2003 vba | Excel Programming | |||
Run Time Error 1004: Application or Object Defined Error | Excel Programming | |||
Run Time 1004 Error: Application or Object Difine Error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Run time error '1004': Generaol ODBC error | Excel Programming |