New Named Range Created Each Time Data Imported into Excel via Macro

  • Thread starter Thread starter Carroll Rinehart
  • Start date Start date
C

Carroll Rinehart

I have noticed that each time I import data into an Excel spreadsheet
via a macro, a new named range (for the same range) is created. This
does not pose a problem, but after a while, I'll have a huge number of
named ranges that will never be used. Why does Excel name the range
and how can I stop this? I noticed in the recorded macro, there was a
line .Name = "drd_5". I commented this out to see what would happen,
but it just renamed the range "ExternalData_5". The next one was
"ExternalData_6", etc.

Thanks,
Carroll Rinehart
 
You could refresh with different parameters or add this

For Each Name In Sheets("Data").Names
Name.Delete
Next Name

or even qualify it if you don't want to delete all
if left(name,3)="Ext" then
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Importing named range from another workbook 5
Contacts from Excel to Outlook 1
Can't located named range 3
Excel Limit to Named Ranges 1
version differences in excel 2007 - use of macros & range names 1
How do you name "range" of data to import/export? 2
name the range of data 3

Back
Top