Hi,

It would seem to me that formula has to match with whatever input ...
Should your formula be deleted, an event macro could re-input it ...

HTH
Cheers
Carim


--
Carim
------------------------------------------------------------------------
Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
View this thread: http://www.excelforum.com/showthread...hreadid=533190