Hi Biff

Thanks for the response. I am happy for the other file to be open at
the same time, however I can't use INDIRECT as it doesn't allow the
file path to be selected.

Any other work around would be appreciated.

Peter


--
PeterW
------------------------------------------------------------------------
PeterW's Profile: http://www.excelforum.com/member.php...fo&userid=6496
View this thread: http://www.excelforum.com/showthread...hreadid=493675