You don't give much to work with. The following macro, placed in the sheet
module, will put the date and time in A1. Format A1 for date and time.
Post back and provide more info on what you have and what you want. To
access the sheet module, right-click the sheet module and select View Code.
"X" out of the module to return to your sheet. HTH Otto
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Range("A1") = Now
Application.EnableEvents = True
End Sub
"srini" wrote in message
...