Guest User

Untitled

a guest
Jan 21st, 2019
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. Private Sub Worksheet_Change(ByVal Target As Range)
  2. Dim A As Range
  3.  
  4. Set A = Range("A2:A" & Rows.Count)
  5.  
  6. If Intersect(A, Target) Is Nothing Then Exit Sub
  7. If Target.Count > 1 Then Exit Sub
  8. Application.EnableEvents = False
  9. Target.Offset(0, 1) = Date
  10. Target.Offset(0, 2) = Time
  11. Application.EnableEvents = True
  12. End Sub
Add Comment
Please, Sign In to add comment