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.