alle namen in een spreadsheet wissen

  • Thread starter Thread starter Sabine
  • Start date Start date
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)
 
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
 
Select a cell where you want the list to start and run this macro:

Sub names()

Selection.ListNames

End Sub
 
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
 
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
 
Back
Top