Tom,
You have to use a loop to delete the names.
Dim Nm As Name
For Each Nm In ThisWorkbook.Names
If Nm.Name Like "Mark_??" Then
Nm.Delete
End If
Next Nm
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Tom" wrote in message
...
Hi
I'd like to delete all name-objects that contain the caption "Mark_XX".
This
takes a very long time when more than 10'000 names of that kind are
available. Is there a faster way than doing it with a loop command?
Tom