You can delete the name and higlight the new range and name it with the
same name you deleted. Don't forget to note the name before you delete
it otherwise your dependent formulas won't work.
--
renegan
------------------------------------------------------------------------
renegan's Profile:
http://www.excelforum.com/member.php...o&userid=10450
View this thread:
http://www.excelforum.com/showthread...hreadid=535108