View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Carrot Carrot is offline
external usenet poster
Posts: 1
Default Last Modified date on cell or column


This works for me, but it has a side effect of not allowing any un-dos.
After changing the tracked cell, CTRL-Z does not do anything. Is there a way
to preserve the undo history?

"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
Exit Sub
End If
Application.EnableEvents = False
Target.Offset(0, 1).Value = Now()
Application.EnableEvents = True
End Sub

REMEMBER: Worksheet code.
Gary''s Student

"Mary" wrote:

Good Morning,
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
update it.
Data Last modified date
BER 3/12/2007
BER 3/1/2007
BER 2/18/2007
SPR 2/18/2007
SPR 2/18/2007
PHL 2/18/2007