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,"?*") )