Hi, I am trying to use this code I googled to get a time stamp populated. The change I need to make is to select rows 10:50 of every alternative column as the range (instead of the A2:A10).
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count > 1 Then Exit Sub
If Not Intersect(Range("A2:A10"), .Cells) Is Nothing Then
Application.EnableEvents = False
With .Offset(0, 1)
.NumberFormat = "dd mmm yyyy"
.Value = Date
End With
Application.EnableEvents = True
End If
End With
End Sub
Thanks for your time.
Bookmarks