Ron Rosenfeld Wrote:


However, an improved Data Validation formula will also flag an error o
A12 or
'a 1'. Use this instead:

=OR(AND(A1="AAA",A1<="ZZZ"),AND(A1="aaa",A1<="zz z"))

That formula in combination with the SUB should do what you want.
--ron


Ron- I tried the this formula, but then it allowed all sorts of othe
entries (ex. aabbcc, a123). I may not be doing something right, s
just let me know if that is the case. Thanks again Ron

--
DejaV
-----------------------------------------------------------------------
DejaVu's Profile: http://www.excelforum.com/member.php...fo&userid=2262
View this thread: http://www.excelforum.com/showthread.php?threadid=38011