Hi Bettany,

I can think of one way, but there is probably a better one out there.

In the interim, in another sheet you could create this range (which goes to
row 1004) Highlight, name it (insert-name-define) and in your cell that you
want the drop down in, data-validation-list-source is: "=mynamedlist" (minus
the quotations and mynamedlist to be replaced with whatever you named your
range.

hth

BigPig


"betany70" wrote:

I need to allow either a specific letter (P,D,E, or A) or a number between 1
and 10 (decimals to two places) in a range of cells. I can create one or the
other but not both - HELP?!?