Go to the sheet with the list; select the range of valid entries and rename
this range to the name used in Data Validation.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"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