Checking range names

[Kenneth Brown]

I have a macro that has to delete specified range names but falls ove
if a target name does not exist (which can happen sometimes - I won'
bore you with the details!). How do I check for the existence of
range name?

 

[Bernie Deitrick]

K,

You could simple use:

On Error Resume Next

prior to your deleting the range names.

HTH,
Bernie
MS Excel MVP