Excel does not automatically use dynamic ranges for drop down lists. I'm not
sure about Excel 2007 but I haven't seen anything about it being any
different than previous versions in that regard.

See this for instructions on creating dynamic ranges:

http://contextures.com/xlNames01.html#Dynamic

--
Biff
Microsoft Excel MVP


"Jerry Bennett" wrote in message
...
thanks a lot, I understand now and have fixed the problem. I guess Excel
automatically assumes you are creating dynamic drop down lists, which is
what
i need, and i was creatiing a named range in the source list of say 200
cells
to allow for additions, when I didn't have to. this all came about when I
converted my 2003 sheet to 2007 and lost all the named ranges and drop
down
lists.
thanks again, you saved me a lot of time
best
--
Jerry bennett
Easthampton, MA


"T. Valko" wrote:

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