Hi
how do I combine the following two codes please? The 1st part works but cannot get it to display date for the second column.
Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Cells.Count > 1 Then Exit Sub
If Intersect(.Cells, Me.Range("C:C")) Is Nothing Then Exit Sub
.Offset(0, -2).Value = Now
If Intersect(.Cells, Me.Range("L:L")) Is Nothing Then Exit Sub
.Offset(0, 2).Value = Now
End With
End Sub
Any help would be greatly appreciated.
Many Thanks
Hoss
Bookmarks