Last Modified date on cell or column
Thank You. Very Helpful.
"Gary''s Student" wrote:
Let's say we enter data in column A and want column B to mark the dte of last
update. So if we enter data into A5, then B5 would automatically record the
date this update occurred. in Worksheet code enter the following macro:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Range("A:A"), Target) Is Nothing Then
Application.EnableEvents = False
Target.Offset(0, 1).Value = Now()
Application.EnableEvents = True
REMEMBER: Worksheet code.
Can you please advise if there is a way or formula to know when was the last
time a cell, column or row was modified without typing everytime that I
Data Last modified date