Hi!

Nothing obviously wrong with the formula.

That was the only thing I could think of that might cause the problem. I
have no other ideas, sorry!

Biff

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