View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DennisW DennisW is offline
external usenet poster
 
Posts: 5
Default Delete the last Range Name

I import a text file into an excel template, and every import creates a name
for the imported data range. Is there a way to (1) prevent creating a Range
Name on import, (2) delete the Range Name at the end of the import macro, or
(3) delete the last Range Name from the .Names Collection?

I don't want to delete all names because I want to keep some of the
existing range names.