How to make it resume if item to delete is not found?

[ks100]

At the beginning and end of my script I need it to check and delete entries under the name manager.

The script should look something like this in plain text:

Look in name manager for item named "States"

Delete ALL entries named "States" regardless of what worksheet or cells they refer to.

***********Script runs normally here, not breaking if nothing was found to delete**********************************

Then at the end of the script, do the same as the beginning, look for items named "States" in the name manager and delete all entries.


When I tried just coding

Please Login or Register  to view this content.

It would give me an error if nothing was found to delete. If nothing is found to delete I need it to just continue on with the script as normal without bothering the user.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[ks100]

Maybe:

Please Login or Register  to view this content.

When you say "YOUR CODE" are you referring to the code to delete the names or my entire script?

[JOHN H. DAVIS]

Your Code to Delete. If a name is not found then the code should resume to the end.