I am using the following format:

=OFFSET(DATA!$B$2,0,0,COUNTA(DATA!$B:$B),1)

Thank you.

"Biff" wrote:

Hi!

What does the formula look like that defines the range?

Biff

"Alex Mackenzie" wrote in message
...
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.