-
Greetings,
How did you redefine 'Names'? As it looks like there is currently a limit (A5:A204) for how big the list could be, try this:
In the 'Define Name' dialogm in the 'Refers To:' box for 'Names':
"=OFFSET(Cases!$A$5,0,0,COUNTA(Cases!$A$5:$A$204),1)"
W/O the quotes...
With the above formula defining the named range, the validation seems to work fine to me.
Does that help?
Mark
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules