Could you tell me how delete the hidden names? Thank you.
T Tom Ogilvy Feb 10, 2004 #2 dim nm as Name for each nm in Thisworkbook.Names if nm.Visible = False then nm.Delete end if Next Untested, but should work.
dim nm as Name for each nm in Thisworkbook.Names if nm.Visible = False then nm.Delete end if Next Untested, but should work.
B Bob Phillips Feb 10, 2004 #3 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)
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)
