Thanks i'll have a look at that,

just out of interest does anybody know why on my home computer if i se
the cell to =now() and format the cell to have seconds in it runs as
clock but on my computer at work it just has the time of when i pu
the command in and dosnt update unless i press f2 to refresh over an
over again

--
scottymellot
-----------------------------------------------------------------------
scottymelloty's Profile: http://www.excelforum.com/member.php...nfo&userid=380
View this thread: http://www.excelforum.com/showthread.php?threadid=31447