April 2006
Beginner
1114 pages
98h 16m
English
workbook.Names
Returns the Names collection containing all the names in the workbook. For example, the following code displays all of the names in a workbook, allowing you to delete them individually:
Dim nm As Name
For Each nm In ThisWorkbook.Names
If MsgBox("Delete " & nm.Name & "?", vbYesNo) = vbYes Then _
nm.Delete
NextRead now
Unlock full access