View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 1,560
Default 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!