Application.ScreenUpdating = True
Application.Calculate
Application.EnableEvents = False '禁用所有事件
If Target.Count > 1 Then Exit Sub
r = Target.Row: c = Target.Column
If c = 3 And Target.Value = "本月合计"
3楼代码依然会出现同样问题!
Application.EnableEvents = False '禁用所有事件
If Target.Count > 1 Then Exit Sub
必须交换位置!!
If Target.Count > 1 Then Exit Sub
Application.EnableEvents = False '禁用所有事件