Oct 15 2020 09:25 AM
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.
Oct 18 2020 10:52 PM
@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