Deleting Range name's listed in the range address box.

[Satnam Patel]

In Excel, in the top corner of the application there is a
box which list the name of a select range (e.g F19 etc..).

when I use the querytables method to import a CSV onto a
worksheet. This range address box, has the name of the
data I have imported.

when I use clear, or qyertytables delete to remove the
imported data - I am unable to remove the name of the
data appearing in the drop-down list for the range box.

Is there anyway to delete this ? or is it not a problem ?

I am concerned because I this rangelist seems to fill up
pretty quickly with imported data ranges..

 

[Debra Dalgleish]

Choose Insert>Name>Define
Select a name in the list
Press the Delete key

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

 

[Debra Dalgleish]

(I cancelled my previous message, because the link wasn't working)

Choose Insert>Name>Define
Select a name in the list
Press the Delete key

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 from Jan Karel Pieterse's site:

http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.htm

It allows you select and delete multiple names

 

[Dave Peterson]

Although, bsmltd.ie still exists, I think this is the preferred site:

http://www.oaltd.co.uk/mvp

 

[Bob Phillips]

Hi Debra,

The link still works for me (?), but Stephen's site is now

http://www.oaltd.co.uk/MVP/Default.htm