Hi
can anyone please tell me how to delete all dynamic names in one time, I have recorded mentioned below a macro can it be concise ?
Thanks in advance
can anyone please tell me how to delete all dynamic names in one time, I have recorded mentioned below a macro can it be concise ?
HTML:
ActiveWorkbook.Names("a").Delete
ActiveWorkbook.Names("bt").Delete
ActiveWorkbook.Names("c").Delete
ActiveWorkbook.Names("d").Delete
ActiveWorkbook.Names("e").Delete
ActiveWorkbook.Names("f").Delete
ActiveWorkbook.Names("h").Delete
ActiveWorkbook.Names("i").Delete
Thanks in advance