michaelspun
New Member
- Joined
- Jan 14, 2014
- Messages
- 6
how do i use same twice but for different rows, sorry i'm very lame in excel.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error GoTo enditall
Application.EnableEvents = False
If Target.Cells.Column = 3 Then
n = Target.Row
If Excel.Range("C" & n).Value <> "" Then
Excel.Range("B" & n).Value = Format(Now, "dd mmm yyyy hh:mm")
End If
End If
enditall:
Application.EnableEvents = True
End Sub
want to use same code but for Column 7 and row F,G.
Sorry for stupid question!
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error GoTo enditall
Application.EnableEvents = False
If Target.Cells.Column = 3 Then
n = Target.Row
If Excel.Range("C" & n).Value <> "" Then
Excel.Range("B" & n).Value = Format(Now, "dd mmm yyyy hh:mm")
End If
End If
enditall:
Application.EnableEvents = True
End Sub
want to use same code but for Column 7 and row F,G.
Sorry for stupid question!