View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Conan Kelly Conan Kelly is offline
external usenet poster
 
Posts: 98
Default Testing for Named Ranges

Hello all,

I had this macro that deleted the Named Range "Table1" at the beginning of it and then redefined it (added it) and the end of the
code.

The problem is that one time through the code, it hit a snag. So after I stopped execution, Table1 is was no longer defined. The
very next time through the code, it snagged on deleting Named Range "Table1".

How would I test to see if the named range even exists before I try to delete it?

Thanks for any help anyone can provide,

Conan Kelly