Hi,
I would like to add a "last date changed" column to a worksheet. I would like to populate the column with the date a user made the last change to any cells in that row. The dates would be row independent and keyed off any changes within the row. Is there... a formula/fct that can be used?
Thanks in advance.
Rusty
Hi i have set the column for the date/time stamp as column F but change to suit!, if you just select a cell or move cells nothing happens but change a cell and the date stamp appears!
The code goes in the worksheet module, right click the sheet tab and choose view code and paste this in!
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub Range("F" & Target.Row).Value = Now() End Sub
Not all forums are the same - seek and you shall find
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks