Code modification help

  • Thread starter Thread starter AndyMP
  • Start date Start date
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
 
Without rewriting the whole thing, change
With .Offset(0, 1)
to
with range("c12")
 
Sorry for the double post, I got an error when posting and that's why I
posted twice. Anyway, this solution works perfectly. Thank You !
 
Back
Top