Hi,

I have to work sometimes with files that for some reason have a huge number of rangenames that refer to workbooks no longer there, and not only that, the range name itsef contains japanese characters, some of the references are dead etc.

since these range names are useless (and sometimes do not allow to change to A1 reference mode) I want to delete them, however the normal sub to kill them (such as these do not delete these invalid names

any workarounds?

otherwise I'll have to delete them one by one, which works flawlessly, and endlessly...

thanks!