macro to show last time a row was updated?

[tonywatsonhelp]

HI Everyone,

I need a macro that when any data is entered into any cell range E13:N103 todays date is entered into Column O on that row,

any ideas who to do this?

Thanks

Tony

 

[Eric W]

Open a copy of your workbook. Right click on the sheet tab and select View Code. Paste this code into the window that opens.

Private Sub worksheet_change(ByVal target As Range)


    If Not Intersect(target, Range("E13:N103")) Is Nothing Then
        Cells(target.Row, "O") = Date
    End If
    
End Sub

Press Alt-Q to close the VBA editor. You're done. If you want the time too, change "Date" to "Now".

 

[tonywatsonhelp]

Thank you Eric this works great

Tony

 

[Eric W]

Glad to help!