Its with a volatile formula, so i need the sheet to update through a
macro instread of having to press F9 until the cell has certin text
already writtin with other formulas.


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=475989