View Single Post
  #1   Report Post  
Satnam Patel
 
Posts: n/a
Default 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..