I'm trying to update all of the Named Ranges in a workbook using a lis
in a spreadsheet and code. This is so I don't have to do the
individually and there is over 300!!

I have tried to use the same syntax as appears in the Names dialog bo
but the ranges do not appear correctly and so will not work.

Any help with this would be fantastic as the cariable option isn'
working!!! Thank

--
Lee Palme
-----------------------------------------------------------------------
Lee Palmer's Profile: http://www.excelforum.com/member.php...fo&userid=2981
View this thread: http://www.excelforum.com/showthread.php?threadid=49520