Is there a way to clear anything that is in Name manager. When my macro opens various files, sometimes there is something in Name Manager that links to other files. I do not want this included in my new file and would like to delete everything out of Name Manager. If I use something specific like ActiveWorkbook.Names("Diff_Type").Delete and "Diff Type" is not in that particular file Macro falls over.
So is there a way to Clear Names Manager no matter what is in it?