Garry
Yes I understand that but Excel will also interpret an entry of a
comma delimited list of values (10,20,30) in the source area and will
present them as single entries in the dropdown. This is what I am
trying to take advantage of.

If I place the formula I presented in my last post in a cell if
returns the contents of the cell so I don't understand why the
validation doesn't interpret it correctly.

David



David

A DV list needs to be stored in a range where each cell in the range
holds 1 listitem. Thus, a delimited list in a cell is 1 listitem.

You need to spread your list across a row (or down a col) of cells!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Two completely different issues!
Providing a range ref is handled differently than providing a delimited
*string list*! (Emphasis on the word "string")
Typing a delimited list persists the listitems as delimited.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion