Validation error: Says range not found and it is there?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to validate a list and it won't except range. range name shows up in
the drop down but I get error message evertime. Have deleted and renamed to
no avail.
 
JMike

You must precede the name with an = sign?

=myname


Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data validation list using filtered range 3
Data Validation and Dynamic Ranges 2
How To Use Range Names In Data Validation Criteria (Not For Lists) 1
Adding to a data validation list 2
Data Validation with dynamic ranges 2
2007 data validation not working 1
Data Validation List Not Working Correctly 5

Back
Top