Hi all,
I can enter the time in a cell by using the =now() and can update it by
hitting the F9 key but how can I make it change automatically to always
remain the same as the computer clock. I would imagine I need a macro to do
it ...can someone please help me.

Thanks....Mark