Advertisement
Guest User

Untitled

a guest
Jul 29th, 2015
204
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. Private Sub Worksheet_Change(ByVal Target As Range)
  2. Dim A As Range, B As Range, Inte As Range, r As Range
  3. Set A = Range("I:I")
  4. Set Inte = Intersect(A, Target)
  5. If Inte Is Nothing Then Exit Sub
  6. Application.EnableEvents = False
  7. For Each r In Inte
  8. r.Offset(0, 1).Value = Date
  9. Next r
  10. Application.EnableEvents = True
  11. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement