hi, is it possible to end a validation list when the list reaches a certain cell?
have a look at the example if u dont understand me 
Re: validation and the end of the list
Have a look at Dynamic Ranges:
http://www.ozgrid.com/Excel/DynamicRanges.htm
TJ
Re: validation and the end of the list
In case you dont like reading all that you can use the offset function as shown in the named range "that" in the attachement.
Justin
Re: validation and the end of the list
The range "them" in this sheet works slightly better, gets rid of space at start (works if numbers go from min to max)
Don’t have an account yet? Register yourself now and be a part of our community!