The original reference works fine even if the source workbook is closed.
Does anyone know of a way to change the reference based on a vaule in
another cell?


--
henryhbb
------------------------------------------------------------------------
henryhbb's Profile: http://www.excelforum.com/member.php...o&userid=15774
View this thread: http://www.excelforum.com/showthread...hreadid=272888