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.

Hi Big-E,

That line of code should work, assuming you have a Name named "index_3" in
the active workbook. You'll get a runtime error 1004 if the name does not
exist.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Big-E wrote:
I'm trying to delete a workbook name using the code I got from
"Record Macro",
ActiveWorkbook.Names("index_3").Delete

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

Any suggestions?
Thanks,
Big-E

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.