能帮我改一下下面的代码么,
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 2 Then Exit Sub
Cells(Target.Row, 11).Value = WorksheetFunction.Text(Now(), "h:m")
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then Cells(Target.Row, 11) = Format(Now(), "h:m")
If Target.Column = 15 Then Cells(Target.Row, 16) = Format(Now(), "h:m")
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then Cells(Target.Row, 11) = Format(Now(), "h:m")
If Target.Column = 15 Then Cells(Target.Row, 16) = Format(Now(), "h:m")
End Sub