Date last changed by Row
Hi,
Think this will work for you.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ThisRow = ActiveCell.Row
Range("A" & ThisRow).Formula = "=Today()"
End Sub
Thanks,
"Steph" wrote:
Hi. I have a data sheet that I would like to add, in ColumnA, the date that
any contents in that given row have been changed. Every row is a unique set
of data. So any changes made to any data in row 5 will have a the date
inserted in A5. Possible? Thank you!
|