Delete Defined Names 1

[gareth001]

Hi all,

I'm wanting to delete all (about 60) the defined names within an excel workbook. I can delete the values of the defined names (end up with "=Sheet1!#REF!") with the below code, but not the name it's self even though I'm displaying it in the message box.

For Each n In ActiveWorkbook.Names
MsgBox n.Name
Range(n.Name).Delete
Next

Thanks for your help

 

[xlbo]

you are deleting the RANGEs not the NAMEs

For Each n In ActiveWorkbook.Names
MsgBox n.Name
n.Delete
Next



Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question