View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Using the =NOW() Function

You don't need a function, you need to use some VBA
Fonz wrote:
When using the =NOW() Function, anytime I make any entries on the sheet, all
of the cells with the function automatically update. Currently, this is the
formula I have from one of the cells:

=IF(F2=0,"",NOW())

WHat should I be adding to it so it doesn't automatically update after a
date and time has been put into place in the cell this formula occupies?
Thanks in advance.