View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default A problem with the function "NOW"

If you want to put current time into a cell, use Control Shift Colon.
--
David Biddulph

"Matthias Dhondt" wrote in message
...
Hi all,

We made a macro, to show the current time in the cell "A1", we used the
function Now()-Today()

When you adapt something in Excel, the time in cell "A1" will
automatically be changed in the current time.

What do we have to change in the macro, that the time don't adapt anymore?

greeting Matthias