What do you mean by 'truncate'?
You don't see it even if you scroll down?

Make sure your NAME covers all the cells in the range.

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"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.