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
Cell and value to compare is,
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
But I want to compare a cell value against the "Name" used for the NamedRange
So the existing NamedRange is set to this
Rich (BB code):
Name: Name1
Scope: Workbook
RefersTo: Sheet1!$A$6:$C$30
Rich (BB code):
G6
Cell value = Name2
Because as it stands at moment a Named range can exist but with the wrong name if value in G6 is changed