1. Named range doesn't contain the last cell in the list.
2. Named range has had an item added to it without redefining range.
3. If you are using a formula for dynamically naming this range, there is an
error in the formula. Is data in last cell of a different type from that
above, for instance?

Paul

"Nightrain" wrote in message
...
I recently created a drop down list with the source data in a seperate tab.
I highlighted all cells in the range and defined a name; the drop down
list
works. However, it keeps truncating the last data row from the list. Any
suggestions? Thanks in advance.