Sorry, I didnt make the problem clear enough, i also have a validation
in the column saying that no two values should be the same- if i enter
a formula into the cell- the validation doesn't work- i need to be able
to have both working---thanks a lot for ur help!


--
hustla7
------------------------------------------------------------------------
hustla7's Profile: http://www.excelforum.com/member.php...o&userid=37760
View this thread: http://www.excelforum.com/showthread...hreadid=573417