View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BCN BCN is offline
external usenet poster
 
Posts: 2
Default Change named cells and keep the links

Hi!

I would like to know if there is any way to change the name of an allready
named cell without modifing the links.

example:

B6 is named 'green' and is =2

then if write in another cell, for example C7, =green+1 instead of writing
=b6+1

if I change the B6 name 'green' for 'chair' how can I make that all the
related cells, C7 for example, change 'green' for 'chair'.

I wish my doubt is clear.

Thanks in advance.