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?



--
Message posted from http://www.ExcelForum.com

K,

You could simple use:

On Error Resume Next

prior to your deleting the range names.

HTH,
Bernie
MS Excel MVP

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

K


---
Message posted from http://www.ExcelForum.com/