That means you have an empty cell at the bottom of the source range. When
you click on a data validation drop down cell it automatically scrolls to
the current selection. So, if the cell is empty it scrolls to the empty
selection at the bottom of your list.

Are you using a dynamic range as the source? If so, your calculation sounds
like it's off by 1 cell.

--
Biff
Microsoft Excel MVP


"Jerry Bennett" <Jerry wrote in message
...
A drop down list referenced from another worksheet with a named range shows
the blank row after the last selection in the list when the drop down
arrow
is clicked in a blank cell in the data entry worksheet. help.
thanks
Jerry Bennett