Test if a Named Range Exists

[FracinDean]

Mr. Excel Forum Members, The following works but I would rather use something that tests to determine if the named range exists, and then delete it only when it does. I prefer to minimize the use of "On Error Resume Next". What is the syntax to test for the existence of the named range "AllRanges"?

On Error Resume Next
ActiveWorkbook.Names("AllRanges").Delete

 

[RoryA]

If you don't want to use On Error Resume Next, you can loop through all the names in the workbook and test the name of each one.

 

[FracinDean]

Lots of named ranges. On Error Resume Next sounds better than I thought. Thank you for the reply.

 

[Sulprobil]

Lots of named ranges. On Error Resume Next sounds better than I thought. Thank you for the reply.

Don't forget
On Error Goto 0
afterwards