alle namen in een spreadsheet wissen

S

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)
 
G

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
 
S

Sam Wilson

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

Sub names()

Selection.ListNames

End Sub
 
S

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
 
S

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
 
Top