Modified date

P

Prixton

Hi,
We have a sheet with several rows and columns that are sometimes updated.
What we want is a date in a column "Modified Date" when something in that
row is modified. Is this possible?

Best regards
 
R

Ron de Bruin

Hi prixton

If you change a cell in Col A:G the date will appear in the H column
Copy this event in a sheet module

Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range
For Each cell In Target.Cells
If Target.Column < 8 Then
Cells(cell.Row, "H").Value = Format(Now, "mm-dd-yy hh:mm:ss")
End If
Next
End Sub
 
Top