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. |
All times are GMT +1. The time now is 09:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com