Dim Lst As Integer, r As Integer
Lst = [B65536].End(xlUp).Row
If Target.Count > 2 Then Exit Sub
r = Target.Row
If r > Lst Then Exit Sub
If Target.Column <> 2 Then Exit Sub
If Target = "" Then
Target.Offset(0, 4) = ""
Else
Target.Offset(0, 4) = Date & Time
End If
End Sub
更新1:
這個是VBA