Thank You Every one that can help with this one in advance!
In the VBA Code bellow, the range is "f" how do i make it f3:f32? and is it possible to put a if statment in the vba so if i delete the "1" in colum 1 or 2 the date stamp disapears?
Private Sub Worksheet_Change(ByVal Target As Range) Dim c As Range application.EnableEvents = False For Each c In Target If c.Column = 1 Or c.Column = 2 Then Range("f" & c.Row).Value = Date Next c Application.EnableEvents = True End Sub
In the VBA Code bellow, the range is "f" how do i make it f3:f32? and is it possible to put a if statment in the vba so if i delete the "1" in colum 1 or 2 the date stamp disapears?
Private Sub Worksheet_Change(ByVal Target As Range) Dim c As Range application.EnableEvents = False For Each c In Target If c.Column = 1 Or c.Column = 2 Then Range("f" & c.Row).Value = Date Next c Application.EnableEvents = True End Sub