If there are blanks in column F followed by data that could cause it.


---
HTH

Bob Phillips

"Gotroots" wrote in message
...
What causes the validation list to change the range to add one or more
empty
cells to the end of the list. When playing round with the defined Name
formula I notice it can change the range to include empty cells. Anyone
got
any thought on this?

=OFFSET(Sheet3!$F$1,0,0,COUNTIF(Sheet3!$F:$F,"?*") )