|
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo 100
Application.EnableEvents = False '禁止触发事件
If Not Application.Intersect(Target, Union(Range("A1:C5"), Range("E1:F5"))) Is Nothing Then
If Not Application.Intersect(Target, Range("A1:C5")) Is Nothing And Target.Value <> "" Then Target.Value = Target.Value * 5
If Not Application.Intersect(Target, Range("E1:F5")) Is Nothing And Target.Value <> "" Then Target.Value = Target.Value * 8
End If
Application.ScreenUpdating = True
100:
If Err.Number = 13 Then
End If
Application.EnableEvents = True '允许触发事件
End Sub |
|