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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Haris DulicCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
klampoAuthor Commented:
Thank you, this solution met and exceeded my expectations.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Office Productivity

From novice to tech pro — start learning today.