Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Private Sub Worksheet_Change(ByVal Target As Range)
- Dim A As Range, B As Range, Inte As Range, r As Range
- Set A = Range("I:I")
- Set Inte = Intersect(A, Target)
- If Inte Is Nothing Then Exit Sub
- Application.EnableEvents = False
- For Each r In Inte
- r.Offset(0, 1).Value = Date
- Next r
- Application.EnableEvents = True
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement