Could you tell me how delete the hidden names?

Thank you.

dim nm as Name
for each nm in Thisworkbook.Names
if nm.Visible = False then
nm.Delete
end if
Next

Untested, but should work.

--
Regards,
Tom Ogilvy


"Stéphane Simard" wrote in message
...
Could you tell me how delete the hidden names?

Thank you.

Hi Stéphane,

Range("myRange").Name.Delete

will do it. This can be a macro, or entered in the immediate window.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Stéphane Simard" wrote in message
...
Could you tell me how delete the hidden names?

Thank you.