Thank. I'm sure that would work. If you want to just send me the code, that would be ok too. The value (A) is string, but since the validation only occurs when a value is entered into A, I could equate another range with an IFTHEN >0 statement when A is not null and configure the validation to that working range.