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