View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Big-E Big-E is offline
external usenet poster
 
Posts: 4
Default Deleting workbook names w/ VB

I'm trying to delete a workbook name using the code I got from "Record Macro",
ActiveWorkbook.Names("index_3").Delet

However, when I execute I get Run-time error 1004
Application-defined or object-defined erro

Any suggestions
Thanks
Big-

Background info
I'm importing a text file and that part is peachy. When I go to overwrite the data from the last import another workbook name is assigned to the same range. I'm concerned about generating a near-infinite number of names as each import indexes the name "index_n+1" I'd be happy to reuse the names or just have a way of deleting an ever larger number.