You mean your named range should refer to Information'!$C$123 insetead of
{test.xls]Information!$C$123

Am i right?

Cheers,
--
AP

"funkymonkUK" a
écrit dans le message de news:
...

if i am correct this will actually delete the named range which is not
exactly what i was looking for as the ranges are used for calculations.


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=555964