atomic2021
New Member
- Joined
- Dec 28, 2016
- Messages
- 9
Hello all,
So, what I'm trying to do is have it so whenever any cell in column A-E is altered, column 'F' will display a timestamp. This might not be too complex, but I'm stuck. Here's what I have so far... I'm doing this in the "View Code" section if that makes a difference.
Sub Start_Process()
On Error GoTo Handler
If Target.Column = 1 Or 2 Or 3 Or 4 Or 5 And Target.Value <> "" Then
Application.EnableEvents = False
Target.Column = (6) = Format(Now(), "dd-mm-yyyy hh:mm:ss")
Application.EnableEvents = True
End If
Handler:
End Sub
So, what I'm trying to do is have it so whenever any cell in column A-E is altered, column 'F' will display a timestamp. This might not be too complex, but I'm stuck. Here's what I have so far... I'm doing this in the "View Code" section if that makes a difference.
Sub Start_Process()
On Error GoTo Handler
If Target.Column = 1 Or 2 Or 3 Or 4 Or 5 And Target.Value <> "" Then
Application.EnableEvents = False
Target.Column = (6) = Format(Now(), "dd-mm-yyyy hh:mm:ss")
Application.EnableEvents = True
End If
Handler:
End Sub