Thread: Macro to record date on sheet data is entered in a cell ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim scrivener Jim scrivener is offline
external usenet poster
  
Posts: 1
Default Macro to record date on sheet data is entered in a cell ?
I need a macro to auto insert in an adjacent call the date data is entered in
a cell.
The following does not work because "Now" changes every day:
=IF(CK3<"",NOW(),"")
Reply With QuoteReply With Quote