Row limit in data validation drop down list?

C

CAToso

Thanks for the replies.

Checking my named range was the first thing I did, and it does includ
all the cells, including the recent additions (they were inserte
alphabetically, as opposed to added to the bottom of the list). I
seems my version of Excel is possessed, because my drop down list i
limited to 666 lines. :eek:

I have deleted some older project codes as a short-term fix, and I wil
look into the dependent list option, but I was trying to follow the KIS
(Keep It Simple Stupid) principle for my users.

If anyone else has suggestions, I'd love to hear them.

Thanks,

~Courtne
 
Top