The obvious question...............

Are you sure that row is included in the named range?

Otherwise, I cannot replicate the problem in 2003 or 2007


Gord Dibben MS Excel MVP


On Tue, 7 Apr 2009 08:45:03 -0700, Nightrain
wrote:

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.