Deleting many named ranges
 

I have a spreadsheet that has a couple of hundred named ranges in it that I
need to delete. Is there an easy way to do this or am I stuck in the Define
Name box deleting them one by one? Thanks in advance for any guidance.

If you're working with names, you might like the Name Manager, a free
add-in that makes it easy to work with defined names. You can download a
copy:

http://www.bmsltd.ie/MVP/Default.htm

It allows you select and delete multiple names

Tom Hayakawa wrote:
I have a spreadsheet that has a couple of hundred named ranges in it that I
need to delete. Is there an easy way to do this or am I stuck in the Define
Name box deleting them one by one? Thanks in advance for any guidance.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Debra,

Thanks for the tip. That worked perfectly.

"Debra Dalgleish" wrote:

If you're working with names, you might like the Name Manager, a free
add-in that makes it easy to work with defined names. You can download a
copy:

http://www.bmsltd.ie/MVP/Default.htm

It allows you select and delete multiple names

Tom Hayakawa wrote:
I have a spreadsheet that has a couple of hundred named ranges in it that I
need to delete. Is there an easy way to do this or am I stuck in the Define
Name box deleting them one by one? Thanks in advance for any guidance.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html