Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing cells in another workbook
do you use notation like
Workbooks("Mybook") if so, change it to Workbooks("Mybook.xls") and it should work on both computers. Including the .xls is always the best course of action. Otherwise it depends on a windows setting to work. -- Regards, Tom Ogilvy "johnh" wrote in message ... I have two workbooks. The first workbook has macros that get values from named cells in the second workbook. Everything works fine on one computer. When I move the directory structure to a second computer and run the macros, I get an error when I attempt to get the values of the named cells in the second workbook. Here's the error. Run-Time error '9' Subscript out of range Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing a different Workbook | Excel Worksheet Functions | |||
Referencing another Workbook | Excel Discussion (Misc queries) | |||
How do I save an Excel workbook so that cells referencing another. | Excel Discussion (Misc queries) | |||
referencing another workbook | Excel Programming | |||
Referencing one workbook in other??? | Excel Programming |