Hi,
Personally, I'd use an approach like the one suggested by JMB, but if
you have users who disable macros when opening files then another
(potentially v slow to implement but) possible approach is to use the
indirect function instead of direct links.

To do this you'd need a reference cell that provides the correct
directory & then convert all your direct formulae to indirect functions
which grab the value from the reference cell.

Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=535343