Hi there,
I have column O "Done by" with a checklist if a task is done. When the task is done someone changes the empty cell to their initials. In column D on the same row is the name of the document that the task was about. I'm trying to make a macro that saves the name of the document (column D) to a Dim, when Column O is being changed. With this Dim I will then send a mail that task x in document x is done.
Pretty simply I assume, but I just can't seem to find the solution.
Thanks!
I have column O "Done by" with a checklist if a task is done. When the task is done someone changes the empty cell to their initials. In column D on the same row is the name of the document that the task was about. I'm trying to make a macro that saves the name of the document (column D) to a Dim, when Column O is being changed. With this Dim I will then send a mail that task x in document x is done.
Pretty simply I assume, but I just can't seem to find the solution.
Thanks!
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim KeyCells As Range
Set KeyCells = Range("O:O")
If Not Application.Intersect(KeyCells, Range(Target.Address)) _
Is Nothing Then
'What goes here...?'
End If
End Sub