Hi,
I'm using the following coding to bring date to the next column. However, I'd also like that if J21:J22 has N/A then it should show N/A in column K rather than a date.
If Not Intersect(Target, Range("J21:J22")) Is Nothing Then
If Target.Count > 1 Then Exit Sub
ActiveSheet.Unprotect Password:="test"
Cells(Target.Row, "K").Value = Format(Now, "dd/mm/yyyy")
ActiveSheet.Protect Password:="test"
THank you
I'm using the following coding to bring date to the next column. However, I'd also like that if J21:J22 has N/A then it should show N/A in column K rather than a date.
If Not Intersect(Target, Range("J21:J22")) Is Nothing Then
If Target.Count > 1 Then Exit Sub
ActiveSheet.Unprotect Password:="test"
Cells(Target.Row, "K").Value = Format(Now, "dd/mm/yyyy")
ActiveSheet.Protect Password:="test"
THank you