Thread: Time Stamps on Edited Sheets?

Hey how can I get a timestamp on one of my excel sheets each time data entered on it is altered/added/removed ?

And i dont meat the:

=TODAY()

function.

I only want the date and time that the sheet was last edited (when i add, or when i change or when i delete a cell/row/column)

Hi anonymust ,

The answer is you need an event macro behind the sheet you want timestamped when something changes.
For example if I want to keep an time stamp in A20 for everytime a value changes on my sheet I'd do

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address <> "$A$20" Then
        Range("A20") = Now()
    End If
End Sub

This code must go behind the worksheet so it is an event macro. Read up at:
http://www.cpearson.com/excel/Events.aspx

You can also search on "VBA Macro Timestamp" to find other examples.