Is cell value the name used as Named range name

[julhs]

This is not about testing for if NamedRange exists, because that will have been established.
But I want to compare a cell value against the "Name" used for the NamedRange
So the existing NamedRange is set to this

Name: Name1
Scope: Workbook
RefersTo: Sheet1!$A$6:$C$30

Cell and value to compare is,

G6
Cell value = Name2

I want a way to test that the value of G6 is infact the "Name:" used for the Named range
Because as it stands at moment a Named range can exist but with the wrong name if value in G6 is changed

 

[jkpieterse]

My name manager has a filter for names overlapping other names. Not exactly the same, but close. Free Name Manager Excel add-in

 

[julhs]

For future readers the link I gave earlier was not specific enough, I should have quantified it was in post #8

skyybot
Thank you so much for that, you have saved my sanity.
It’s given me exactly what I was after; now just have to figure out the way to utilise it to delete the ones I don’t want.
Probably easier said than done, but going to see if I can figure it.
Many thanks
Julhs

 

[julhs]

jkpieterse
I've not installed it but have read through the info.
I’m curious about it but not going to investigate it until I have put this (part-time) pain in the proverbial project to bed
Many thanks for you help
julhs