Need Excel MACRO written in order to delete conflicting names

%3CLINGO-SUB%20id%3D%22lingo-sub-3301865%22%20slang%3D%22en-US%22%3ENeed%20Excel%20MACRO%20written%20in%20order%20to%20delete%20conflicting%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3301865%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20review%20my%20Case%20%231038686167.%26nbsp%3B%20Per%20Warren%2C%20he%20advised%20that%20I%20contact%20the%20Tech%20Community%20to%20write%20a%20macro%20that%20will%20delete%20the%20conflicting%20names.%26nbsp%3B%20Currently%20I%20receive%20an%20error%20message%20%22The%20name%20_CH67%20already%20exists%22%20when%20I%20COPY%20a%20worksheet%20from%20a%20source%20workbook%20to%20a%20destination%20workbook.%26nbsp%3B%20I%20have%20delected%20all%20names%20in%20the%20Names%20Manager.%26nbsp%3B%20These%20conflicting%20names%20are%20somewhere%20embedded%20in%20my%20workbook%20where%20I%20cannot%20see.%26nbsp%3B%20Warren%20tried%20to%20write%20a%20macro%20to%20delete%20them%2C%20but%20failed.%26nbsp%3B%20The%20macro%20needs%20to%20be%20written%20by%20an%20expert%20from%20the%20Tech%20Community.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3301865%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECommunity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3302443%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Excel%20MACRO%20written%20in%20order%20to%20delete%20conflicting%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3302443%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1380153%22%20target%3D%22_blank%22%3E%40karice62%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%20Jan%20Karel%20Pieterse's%20free%20%3CA%20href%3D%22https%3A%2F%2Fjkp-ads.com%2Fexcel-name-manager.asp%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EName%20Manager%20add-in%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20can%20display%20hidden%20names%20and%20it%20can%20delete%20defined%20names%20in%20bulk.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3302423%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Excel%20MACRO%20written%20in%20order%20to%20delete%20conflicting%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3302423%22%20slang%3D%22en-US%22%3EPlease%2C%20is%20there%20someone%20in%20the%20Excel%20tech%20community%20who%20can%20help%20me%20delete%20the%20conflicting%20names%3F%20These%20names%20do%20not%20appear%20in%20the%20Names%20Manager.%20There%20are%20too%20many%20conflicting%20names%20to%20accept%20or%20rename.%20Can%20anyone%20help%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3301905%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Excel%20MACRO%20written%20in%20order%20to%20delete%20conflicting%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3301905%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1380153%22%20target%3D%22_blank%22%3E%40karice62%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello!%20You've%20posted%20your%20question%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Ftech-community-discussion%2Fbd-p%2FCommunityQuestions%22%20target%3D%22_blank%22%3ETech%20Community%20Discussion%20space%3C%2FA%3E%3CSPAN%3E%2C%20%3C%2FSPAN%3Ewhich%20is%20intended%20for%20discussion%20around%20the%20Tech%20Community%20website%20itself%2C%20not%20product%20questions.%20I'm%20moving%20your%20question%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3EExcel%20space%3C%2FA%3E%20-%20please%20post%20Excel%20questions%20here%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Please review my Case #1038686167.  Per Warren, he advised that I contact the Tech Community to write a macro that will delete the conflicting names.  Currently I receive an error message "The name _CH67 already exists" when I COPY a worksheet from a source workbook to a destination workbook.  I have delected all names in the Names Manager.  These conflicting names are somewhere embedded in my workbook where I cannot see.  Warren tried to write a macro to delete them, but failed.  The macro needs to be written by an expert from the Tech Community.

3 Replies

@karice62 

Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future. 

Please, is there someone in the Excel tech community who can help me delete the conflicting names? These names do not appear in the Names Manager. There are too many conflicting names to accept or rename. Can anyone help?

@karice62 

Try Jan Karel Pieterse's free Name Manager add-in 

It can display hidden names and it can delete defined names in bulk.