View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Is it possible to find out when data was entered into a cell

For individual cells, none that I know of.

You could find the last saved date/time which might tell you something
assuming you have a backup of the version at cutoff date for comparison.

Sub dateit()
ActiveSheet.Range("A1").Value = "Last Saved : " & _
Format(ThisWorkbook.BuiltinDocumentProperties("Las t Save Time"), _
"yyyy-mmm-dd hh:mm:ss")
End Sub


Gord Dibben MS Excel MVP


On Tue, 30 Sep 2008 00:01:01 -0700, Jaybee
wrote:

Some data was entered into an Excel worksheet after a cut off date. I there a
way of telling when the data was entered.