When the Data Validation dropdown is opened, it tries to find an item in
the list that matches the current content of the cell.

Maybe your dynamic range includes a blank cell at the end, and the cell
with the Data Validation list is empty. If that's the case, you may need
to adjust the formula for your dynamic range, perhaps subtracting 1 for
the contents of a heading cell.

Alex Mackenzie wrote:
For a data validation list, the default display length appears to be 8 lines.
If I am using a dynamic data range that is longer than 8, the dropdown list
displays the values at the end of the range. I have read various articles on
size and display of a dropdown list but have not found any reference to
this. Is there a way to format the data validation so that the drop down
list starts at the top of the range, or do I need to use a static range?
Thank you.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html