Worksheet Change Event - track changes
Hi Karen
Try this out. It puts a date in P1 when the cells in your stated
range change. Put it in the worksheet object you want it to run from.
Take care
Marcus
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("A2:N5000")) Is Nothing Then
Range("P1").Value = Now()
End If
End Sub
|