Excel (VBScript) - Date Stamp when Row is Ammended

Soldato
Joined
10 May 2004
Posts
3,790
Location
East Yorkshire, UK
Hi

I have a bit of code, but I am trying to amend it to include:-

- Delete the date if the row is empty

Cheers

Code:
Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Row > 12 Then Cells(Target.Row, "L") = Date
End Sub
 
Last edited:
Back
Top Bottom