I try that and get a reference error
Think INDIRECT requires that the source workbooks need to be open
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Pester" wrote in message
...
Max, Thanks for the help. Now, what if I want to look for information in a
Sheet or tab that is in a different Excel file, with a different path.
Now,
all the 50 sheet names will be in the other excell file. Do I need to put
the path whole path from drive/folder etc in the cells? I try that and get
a
reference error