Named Cells (Ranges)
 

If I name a cell, and want to change the name, in Excel 2003, there is no
easy way to do it. Do I have to delete the name, and add back a new one?
Very tedious...

Named Cells (Ranges)
 

You do, unless you Get hold of Jan Karel Pieterse's NameManager utility,
http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp.

--
__________________________________
HTH

Bob

"Derek Hart" wrote in message
...
If I name a cell, and want to change the name, in Excel 2003, there is no
easy way to do it. Do I have to delete the name, and add back a new one?
Very tedious...

Named Cells (Ranges)
 

Hi,

Actually you don't need to delete the old range name, just add the new name.
A range can have as many names as you like. Of course that clutters up the
list, but you can come back at some later time and delete unwanted names.

--
Thanks,
Shane Devenshire


"Derek Hart" wrote:

If I name a cell, and want to change the name, in Excel 2003, there is no
easy way to do it. Do I have to delete the name, and add back a new one?
Very tedious...

Named Cells (Ranges)
 

Just to add...

Be careful before you delete the old names. You'll want to change anything that
uses them--formulas, other names, VBA code...



ShaneDevenshire wrote:

Hi,

Actually you don't need to delete the old range name, just add the new name.
A range can have as many names as you like. Of course that clutters up the
list, but you can come back at some later time and delete unwanted names.

--
Thanks,
Shane Devenshire

"Derek Hart" wrote:

If I name a cell, and want to change the name, in Excel 2003, there is no
easy way to do it. Do I have to delete the name, and add back a new one?
Very tedious...




--

Dave Peterson

Named Cells (Ranges)
 

That's one way to slow your workbook down, seeing as the redundant names
will all get recalculated every time.

--
_______________________________
HTH

Bob

"ShaneDevenshire" wrote in
message ...
Hi,

Actually you don't need to delete the old range name, just add the new
name.
A range can have as many names as you like. Of course that clutters up
the
list, but you can come back at some later time and delete unwanted names.

--
Thanks,
Shane Devenshire


"Derek Hart" wrote:

If I name a cell, and want to change the name, in Excel 2003, there is no
easy way to do it. Do I have to delete the name, and add back a new one?
Very tedious...