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