Hi All,
I am using a simple macro that date/time stamps an adjacent cell when data is entered in a certain column...
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub
If Not Intersect(Target, Range("B:B")) Is Nothing Then
On Error Resume Next
Application.EnableEvents = False
Target.Offset(, -1) = Now
Application.EnableEvents = True
On Error GoTo 0
End If
End Sub
Is there anyway I can merge the following code...
If Target.Value = vbNullString Then
Range("A" & Target.Row) = vbNullString
to get the date/time stamp to automatically clear, if the data is removed again? (I am aware of the laziness of the function I am requesting here)
Much love xx
Bookmarks