"Biff" wrote:
I need to do this by entering 1, 2 or 3 in column A

I don't see anything that mentions values higher than 3.

Agreed. But I was hinting at the possibility
of a "wrong" input of a number higher than
what is mentioned in the OP
(the built-in "error trap" part of it)

Anyway, the OP seems happy with both options <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---