Get a copy of Jan Karel Pieterse's (with Charles Williams and Matthew Henson)
Name Manager to help:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

And don't forget your code will have to change (well, if you used any of those
names in the VBA).



Sige wrote:

Hi There,

I am wondering whether it is possible to rename Defined Names ...
What is the most convenient way?

The way I would do it.
- Copy the same "Refers to" ....(range, formula,...) as the orginal
Defined Nmae
- Give it the New Name
& Replace the Old Name with the New Name via "Flexfind" (JKP:
http://www.jkp-ads.com)
-Delete the Old name

Downside ... naah, there is none. It can handle the names used in Data
Validation, Conditional Formatting ,... as well!

Just wondering whether you have other ways ( a direct one, instead of
the creation, finding and deletion way described above) to handle
"renaming" Defined Names.

Thanks for your comments,
Sige

--

Dave Peterson