Recording the date and time when a record is modified

[Sheri]

Recording the date and time when a record is modified -
when any information in updated in a range of cells,
record the date and time in another cell.

 

[Paul B]

Sheri, here is one way

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'will put date in column B when something is put in A
If Target.Count > 1 Then Exit Sub
If Target.Column = 1 Then
Target.Offset(0, 1).Value = Now()
End If
End Sub

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **