Excel 2002 - How to delete all defined names {references} in workbook

[Frank Kabel]

Hi
Try Jan Karel Pieterse and Charles Williams's Name Manager add-in,
which
you can find at:

http://www.bmsltd.ie/MVP

 

[Bob Phillips]

Using VBA


For Each nme In ActiveWorkbook.Names
nme.Delete
Next nme

--

HTH

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

 

[Jason Scoggins]

Hello,

I've got a workbook that another person modified by copying and pasting data
from another worksheet. The problem is, they somehow created references in
the process. When you go to Insert --> Name --> Define there are hundreds of
Names defined in the workbook. The only way to remove these is select them
one by one and press delete.

Does anyone know of a faster way to accomplish this?

Thanks in advance,

Jason

 

[Jason Scoggins]

Thanks!!

That worked perfectly.

Using VBA


For Each nme In ActiveWorkbook.Names
nme.Delete
Next nme

--

HTH

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

hundreds