Determine the validity of a range name

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping Names in Mail Merge 0
Merging from an Excel file with graphics 1
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
range naming and conditional creation 4
Finding a Name 2
Excel 2003 dynamic named range for the values in a pie chart 1
Name the range AFTER copied to new sheet 6

Top