Hi

InsertNameDefine
Select the name to rename. Type in the new name. Add
On worksheets, where the name was used, ReplaceAll OldName with NewName.
Select ranges with data validation/conditional formatting, and replace names
there too.
Delete old name.

Probably you can write a procedure for all this too - i.e. the user is
asked, which name is to be replaced, and the new name, and all the rest is
done by code.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Sige" wrote in message
oups.com...
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