Rhonda

I just put 3000+ numbers in a list and selected it as the validation source.
No problem.

What does your data look like ?

Regards

Trevor


"Rhonda Pugh" <Rhonda wrote in message
...
I would like to have several list in a particular cell. However, I have
found
that Excel is limited to the number of items that can go in a list. Why?

Or how can I list a choice of 30 or more items in one cell?