View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default How do I find excel names that do not show in the define function

Hi Smitty,
You can use a macro by "Mike" kind of like you just a single
unidentifiable username in the newsgroup.

http://groups.google.com/groups?thre...0microsoft.com

the macro will go through the list of name and delete each one.

Sub DeleteallNames()
Dim nName As Name
For Each nName In Names
nName.Delete
Next nName
End Sub

Google Groups has sure gone downhill, the purpose of posting
code is so that it can be copied, Google site is taking forever
when it is functioning and the new layout for GG causes major
problems and now the messing up mouse and context menus.
I would have rather have just pointed you to the code, but I
have bookmarklets to change things (and could probably
work from original text).

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Smitty" wrote in message ...
,I was given the file. It has many names some using Asian characters. I
need none of them, but I get a long annoying sequence of queries regarding
them whenever I try to copy a sheet. (this I do often) How can I find and
eliminate these names? They do not show up when I click on the insert names
menu.