View Single Post
 
Old 10-06-2017, 08:12 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

Right click the worksheet tab and choose View Code, then paste this in:

Code:
Private Sub Worksheet_Change(ByVal Target As Range)
    Dim cell                  As Range
    On Error GoTo oops
    If Not Intersect(Target, Range("B3:AS38")) Is Nothing Then
        Application.EnableEvents = False
        For Each cell In Intersect(Target, Range("B3:AS38")).Cells
            Cells(cell.Row, "AT").Value = Date
        Next cell
    End If
oops:
    Application.EnableEvents = True
End Sub
Reply With Quote