Clear defined names in 365 for Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-1784517%22%20slang%3D%22en-US%22%3EClear%20defined%20names%20in%20365%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1784517%22%20slang%3D%22en-US%22%3E%3CP%3EDear%2C%20Somebody%20knows%20how%20can%20I%20clear%20all%20defined%20names%20in%20escell%20365%20for%20Mac.%20The%20process%20can%20looks%20like%20similar%20to%20windows%2C%20but%20in%20Mac%20system%20is%20very%20diferent.%20There%20are%20no%20way%20to%20clear%20all%20names%20o%2C%20only%20is%20possible%20clear%20one%20by%20one.%20This%20is%20very%20unconfortble.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1784517%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1794145%22%20slang%3D%22en-US%22%3ERe%3A%20Clear%20defined%20names%20in%20365%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1794145%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F833917%22%20target%3D%22_blank%22%3E%40rodrigoaraujoar%3C%2FA%3E%26nbsp%3BA%20search%20on-line%20%22delete%20all%20named%20ranges%20VBA%22%20gave%20many%20examples%20on%20how%20to%20do%20this%20with%20a%20small%20piece%20of%20VBA%20code.%20This%20is%20just%20one%20of%20many%20similar%20solutions%20found.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-visual%22%3E%3CCODE%3ESub%20DelNamedRnges()%0A%0ADim%20N%20As%20Name%0A%0AFor%20Each%20N%20In%20Names%0A%0A%20%20%20%20ActiveWorkbook.Names(N.Name).Delete%0A%0ANext%0A%0AEnd%20Sub%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Dear, Somebody knows how can I clear all defined names in escell 365 for Mac. The process can looks like similar to windows, but in Mac system is very diferent. There are no way to clear all names o, only is possible clear one by one. This is very unconfortble.

1 Reply

@rodrigoaraujoar A search on-line "delete all named ranges VBA" gave many examples on how to do this with a small piece of VBA code. This is just one of many similar solutions found.

 

Sub DelNamedRnges()

Dim N As Name

For Each N In Names

    ActiveWorkbook.Names(N.Name).Delete

Next

End Sub