how to find date and time of each cell ?
 

Does anyone know if there is a way to find out when each cell in the excel
was made/changed ? date and time? maybe there is a program for it or
software?
please let me know at

thank you !

how to find date and time of each cell ?
 

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count 1 Then Exit Sub
Set r = ActiveSheet.UsedRange.SpecialCells(xlComments)
If Intersect(r, Target) Is Nothing Then
Else
Target.Comment.Delete
End If

With Target
.AddComment
.Comment.Visible = False
.Comment.Text Text:=Format(Now(), "mm/dd/yyyy")
End With
End Sub

This macro should be pasted in the worksheet code area. Whenever a cell is
changed, the time and date are recorded as a comment for that cell.
--
Gary''s Student - gsnu200769


"mikerush7" wrote:

Does anyone know if there is a way to find out when each cell in the excel
was made/changed ? date and time? maybe there is a program for it or
software?
please let me know at

thank you !

how to find date and time of each cell ?
 

Take a look he

http://www.mcgimpsey.com/excel/timestamp.html

Alternatively, see XL Help for Track Changes, which requires that you
share the workbook.

In article ,
mikerush7 wrote:

Does anyone know if there is a way to find out when each cell in the excel
was made/changed ? date and time? maybe there is a program for it or
software?
please let me know at

thank you !