Hello,
I would like to modify this module. It was written so that any change made in column A would produce a date stamp in column b and a time stamp in column c. I need to a repeat this same process in column f. Any changes made in column f should produce a date stamp in column g and a time stamp in column h. How do I modify this module to include column f?
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("b2:b1000")) Is Nothing Then
Target.Offset(0, 1) = Date
Target.Offset(0, 2) = Time
End If
End Sub
![]()
Bookmarks