How to insert a last modified date and time into a cell when another cell in the row is modified?

I have an excel spread sheet that has about 10 columns of data. I want to make a column named Last Modified. Then on each row, when a piece of data in one of the cells are changed, the Last Modified column will update with a new Date and Time.
klampoAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Haris DjulicConnect With a Mentor Commented:
Here is the code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1:E43")) Is Nothing Or Target.Cells.Count > 1 Then Exit Sub
Me.Range("F" & Target.Row) = Date & " " & Time
End Sub

Open in new window

0
 
klampoAuthor Commented:
Here is an example.
Below is what I currently have.
excel1.pngNow assume that I made a change in Row 3, Last modified shows the date and time of the change. See the screenshot below with the parts highlighted yellow.
excel1changed.pngThat is what I am trying to accomplish. Each row has a cell that reports the date and time change of any cell in that row.
0
 
klampoAuthor Commented:
Thank you, this solution met and exceeded my expectations.
0
All Courses

From novice to tech pro — start learning today.