LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Named sheet to change Cells names Skrapik New Users to Excel 3 August 11th 07 04:46 AM
inserting a named range into new cells based on a named cell Peter S. Excel Discussion (Misc queries) 1 June 4th 06 03:53 AM
#REF on Links to Named Range in External Workbook [email protected] Excel Discussion (Misc queries) 1 April 6th 06 03:02 PM
Cell just shows formula after named region var change John Excel Worksheet Functions 4 January 19th 06 02:33 AM
Named range links to external workbook, help! WitchMaster Charts and Charting in Excel 2 October 11th 05 12:07 PM


All times are GMT +1. The time now is 10:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"