Testing For a RangeName
If you know you want to delete the name, just delete it and ignore any error.
on error resume next
activeworkbook.names("somenamehere").delete
on error goto 0
JCS wrote:
Hello Everyone,
I'm not very good at VBA, hiowever, I do have to occaisionally use it. Is
there a way to programatically test for a range name and then delete it if
it exists? Many thank in advance!
John
--
Dave Peterson
|