J
Jim Brent
I have a number of named ranges in a spreadsheet and I want to verify whether
or not a generated name is a valid named range within the worksheet. I tried
this:
For each name in Application.names
if name = testname then...
but... name comes up as the cell range not the name it was given.
How do I check to see if a range name is valid?
or not a generated name is a valid named range within the worksheet. I tried
this:
For each name in Application.names
if name = testname then...
but... name comes up as the cell range not the name it was given.
How do I check to see if a range name is valid?