|
楼主 |
发表于 2019-9-2 16:14
|
显示全部楼层
爱疯 发表于 2019-9-2 15:47
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then
If Targe ...
感谢大神,你写的如果定义qc是不是拆开就是下面这样的?下面这个我自己试了一下 跟你写的效果一样。
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then
If Target.Count = 1 Then
If Target = "" Then
With Application
.EnableEvents = False
.Union(Target, .Intersect(Target.EntireRow, Range("c:c,d:d,f:f,k:k"))).ClearContents
.EnableEvents = True
End With
End If
Else
With Application
.EnableEvents = False
.Union(Selection, .Intersect(Selection.EntireRow, Range("c:c,d:d,f:f,k:k"))).ClearContents
.EnableEvents = True
End With
End If
End If
End Sub
|
|