Could post how you think you solved the problem, please.


Gord

On Tue, 7 Apr 2009 11:25:01 -0700, Nightrain
wrote:

What I meant by "truncating" was the fact that I entered 42 rows of data into
the accepted range but only 41 rows of data would actually show in the drop
down list. However, I think I solved my own question anyways, thanks for the
replies.

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