This Event macro uses A1 to record time changes for row 1:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim s As String
s = "A2:IV1"
If Intersect(Target, Range(s)) Is Nothing Then Exit Sub
Range("A1").Value = Now
End Sub

--
Gary''s Student - gsnu200739


"pmj" wrote:

I am looking for a formula that will put the time & date into a cell anytime
data in a row is changed.