Please help, I am trying to get a time stamp in two places on the same sheet but controlled by two different cells.
here is what I was trying but it's not working.
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("d:d")) Is Nothing Then Target.Offset(0, -1) = Date End If If Not Intersect(Target, Range("f:f")) Is Nothing Then Target.Offset(0, -1) = Date End If End Sub
Bookmarks