Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Time Error 424
I have a macro which runs while a number of workbooks are open. I kee
getting a Run Time Error 424 when I do the following: Workbooks(workbook1.xls).Worksheets("Data").Range( "PasteCell").Value Workbooks(workbook2.xls).Worksheets("Supply").Rang e("CopyCell").Value I know that both worksheets are open and that the sheet names ar correct as well as the named ranges. What am I doing wrong? Thank -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Time Error 424
Put the workbook names in quotes. E.g.,
Workbooks("workbook1.xls").Worksheets("Data").Rang e("PasteCell"). Value = Workbooks("workbook2.xls").Worksheets("Supply").Ra nge("CopyCell") ..Value -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ExcelMonkey " wrote in message ... I have a macro which runs while a number of workbooks are open. I keep getting a Run Time Error 424 when I do the following: Workbooks(workbook1.xls).Worksheets("Data").Range( "PasteCell").Va lue = Workbooks(workbook2.xls).Worksheets("Supply").Rang e("CopyCell").V alue I know that both worksheets are open and that the sheet names are correct as well as the named ranges. What am I doing wrong? Thanks --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Time Error 424
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
run-time error '91'-Close Button error | Excel Discussion (Misc queries) | |||
Run time error 1004, General ODBC error | New Users to Excel | |||
Run-time error '11' & Run-time error '1004' | Excel Programming | |||
Run-time error '11' & Run-time error '1004' | Excel Programming |