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