Hi Roger,

I'm not sure if there were some typos in the defined names listed in your
first response:

First =AND(CODE(MID($A2,1,1))64,CODE(MID($A2,1,1))<91)
Second =AND(CODE(MID($A2,2,1))64,CODE(MID($A2,2,1))<91)
Number =AND(LEN($A1)=9,ISNUMBER(--MID($A1,3,6)))
Last =AND(CODE(RIGHT($A8,1))64,CODE(RIGHT($A8,1))<68)

Should all cell refs read above as: "$A1" ?
(think there's some cell refs reading: $A2, $A1, $A8)

And I don't know why, but I also found that I could only get your suggestion
working properly over here (I'm using Excel 97) by putting the whole string
of formulas together in the "Formula:" box in the DV (with col A selected):

=AND(CODE(MID($A1,1,1))64,CODE(MID($A1,1,1))<91,C ODE(MID($A1,2,1))64,CODE(
MID($A1,2,1))<91,LEN($A1)=9,ISNUMBER(--MID($A1,3,6)),CODE(RIGHT($A1,1))64,C
ODE(RIGHT($A1,1))<68)

Anyway, thought your suggestion was by far, the better one ..

Perhaps you could send a copy of your test file over ?
To: demechanik <at yahoo <dot com

Thanks
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--