Data Validation criteria

I have a cell with data validation on it that refers to a dynamic named range. I would like to append the choice "New" to the list of valid entries. Is it possinle to do this as part of the data validation set up for the cell as opposed to adding this entry to the range on which it is based?

No, you can use a delimited list, or a range, but not both.


blatham wrote:
> I have a cell with data validation on it that refers to a dynamic named
> range. I would like to append the choice "New" to the list of valid
> entries. Is it possinle to do this as part of the data validation set
> up for the cell as opposed to adding this entry to the range on which
> it is based?
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html