A
AndyMP
I found this code on the web for updating a cell with the time and date
whenever a specified range of cells is edited. In order to do this it is
using the Worksheet_change function. The code prints the time and date in the
cell beside the one that is changed. What I would like to do is have the time
and date printed in one, single specific cell. Can this be done ?
Here is the code....
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count > 1 Then Exit Sub
If Not Intersect(Range("A2:A10"), .Cells) Is Nothing Then
Application.EnableEvents = False
If IsEmpty(.Value) Then
.Offset(0, 1).ClearContents
Else
With .Offset(0, 1)
.NumberFormat = "dd mmm yyyy hh:mm:ss"
.Value = Now
End With
End If
Application.EnableEvents = True
End If
End With
End Sub
whenever a specified range of cells is edited. In order to do this it is
using the Worksheet_change function. The code prints the time and date in the
cell beside the one that is changed. What I would like to do is have the time
and date printed in one, single specific cell. Can this be done ?
Here is the code....
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count > 1 Then Exit Sub
If Not Intersect(Range("A2:A10"), .Cells) Is Nothing Then
Application.EnableEvents = False
If IsEmpty(.Value) Then
.Offset(0, 1).ClearContents
Else
With .Offset(0, 1)
.NumberFormat = "dd mmm yyyy hh:mm:ss"
.Value = Now
End With
End If
Application.EnableEvents = True
End If
End With
End Sub