Checking range names

K

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?
 
B

Bernie Deitrick

K,

You could simple use:

On Error Resume Next

prior to your deleting the range names.

HTH,
Bernie
MS Excel MVP
 
Top