Hi,
Thanks for pointing me to the indirect() function, it's been very
helpful!
Pity that it only works when the other file is open as mentioned, some
sheets I want to use it in link to 10+ files. I'll have a closer look
at that pull file (Thanks!) but seeing im a n00b when it comes to
vb
I'll do this with a bit clearer head tomorrow ;)
Thanks for the help!
Cheers, Chris
--
Negentropy
------------------------------------------------------------------------
Negentropy's Profile:
http://www.excelforum.com/member.php...o&userid=27525
View this thread:
http://www.excelforum.com/showthread...hreadid=470451