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

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..

Choose InsertNameDefine
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


Satnam Patel wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

Choose InsertNameDefine
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

Satnam Patel wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

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

Debra Dalgleish wrote:

Choose InsertNameDefine
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

Satnam Patel wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

--

Dave Peterson

Hi Debra,

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

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

--
HTH

Bob Phillips

"Debra Dalgleish" wrote in message
...
(I cancelled my previous message, because the link wasn't working)

Choose InsertNameDefine
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

Satnam Patel wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html