Sir Rossdale the Gallant
New Member
- Joined
- Apr 6, 2022
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Hello,
So I'm using this VBA code to date stamp when data is entered into a cell, but is it possible to keep the cell empty if I remove that data?
Thanks in advance!
So I'm using this VBA code to date stamp when data is entered into a cell, but is it possible to keep the cell empty if I remove that data?
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A:A")) Is Nothing Then
Application.EnableEvents = False
Range("G" & Target.Row & ":G" & (Target.Row + Target.Rows.Count) - 1).Value = Date
End If
Application.EnableEvents = True
End Sub
Thanks in advance!