alle namen in een spreadsheet wissen

[Sabine]

Hallo allemaal,

ik zoek een zeer simple VBA routine om alle namen in de actieve workbook te
verwijderen, wie weet deze (zeker zeer simpele) code?

Alvast bedankt,

Sabine (met een lichte black-out)

 

[Gary''s Student]

This routine will remove all the Defined Names in the Active wrokbook:

Sub ClearNames()
Dim n As Name
For Each n In ActiveWorkbook.Names
n.Delete
Next
End Sub

 

[Sam Wilson]

Select a cell where you want the list to start and run this macro:

Sub names()

Selection.ListNames

End Sub

 

[Sabine]

Exactly wat I was hoping for, thank you very much - and excuses for me
writing my post in Dutch, I was in a hurry and did't realize that I was in
the english-speaking newsgroup

Beste regards,

Sabine

 

[Sabine]

Not exactly what I was hoping for, but completely my fault when I am posting
a request in Dutch, SORRY! I was looking for a routine to delete all names
in a spreadsheet, see the other answer, THANKS ANYWAY

Sabine