Thanks, Mike, for your help, so quicly !
I think "deleting all names at once" is a missing tool in Excel: could be so usefull to clean up files.
In fact I've written VBA to extract some important information from a larger Excelfile (="source") to an "extract". Since there is a sheet in the "source" with three charts on it, the easiest way to insert this sheet into the "extract", was to simply copy the whole sheet, but this is taking about 1360 names of the "source" to the "extract" adding some hundreds of unneeded kb.
I can't import your solution in my macro, or can I ? (And it should be working for hundreds of other users, since my programm is succesfull in the "field".)
Or is there a way to prevent all those unnessecary names to "come over" ?
Would be delighted to make a 50 kb instead of 500 kb "extract" in 5 seconds. (deleting all names takes 148 seconds on my machine - 2 years old !)
regards,
Erik