Hi

I got a lot of named ranges which refer to a specific workbook however
the values.

for example i have a names range with the following value
='[test.xls]Information'!$C$123"

is there a way to go through all the ranges and delete only the
reference to the test workbook?


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