Check if a Named Range exists (global scope) and tell the user about confilcting situation

I saw some information on but I need to be a bit more specific.

I have a macros that names the headers of a region of data. It error checks if the proposed header names aren't valid names. I've attached.

I want to check if the a named range exists in the ActiveWorkbook. I've tried the code below, as an if to check if the names exist in the the workbook. It doesn't quite work. I've attached an example sheet for reference as well.

Any help would be much appreciate.

Please Login or Register  to view this content.

So basically, I want to get a pop that says: hey wait, that name already exists, rename it. Eventually I want to put in an input box that allows for people to rename on the spot but thats the next step.