Hi everyone
How am I able to insert the username in the column "Closed by" and the actual date in column "Date for closing Claim Internal"?
I tried with this VBA code, but it only take line 31.
Private Sub Closed_by()
If Range("AJ31") = "Closed" Then
Range("AK31").Value = Application.UserName
End If
End Sub
How am I able to insert the username in the column "Closed by" and the actual date in column "Date for closing Claim Internal"?
I tried with this VBA code, but it only take line 31.
Private Sub Closed_by()
If Range("AJ31") = "Closed" Then
Range("AK31").Value = Application.UserName
End If
End Sub