Thread: get date with now() today() but dont update with recalc
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
robert w
 
Posts: n/a
Default get date with now() today() but dont update with recalc
is there a way to stop a cell being recalculated when useing the now()
function ?
e.g if(a1="order",c1=now(),"")....but i dont want the cell updated after its
inital value is obtained.
Reply With QuoteReply With Quote