Thanks guys.

Both those solutions worked well, I guess it just a matter of not
thinking too into it. One more question: how can I clear a cell based
on an event, without a macro.

For instance if A1=B1, then C1=0? Ideas?

Thanks
Paul


--
Paul987
------------------------------------------------------------------------
Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850
View this thread: http://www.excelforum.com/showthread...hreadid=479777