Sub xx()
Set d1 = CreateObject("scripting.dictionary")
Set d2 = CreateObject("scripting.dictionary")
With [AF666:AO866]
.Interior.ColorIndex = xlNone
For i = 1 To .Count
d1(.Item(i).Text) = ""
Next
End With
With [A39:J1038]
For i = 1 To .Count
If d1.exists(.Item(i).Text) Then
d2(.Item(i).Text) = ""
.Item(i).ClearContents
End If
Next
End With
With [AF666:AO866]
For i = 1 To .Count
If d2.exists(.Item(i).Text) Then
.Item(i).Interior.ColorIndex = 7
End If
Next
End With
End Sub
追é®ç°å¨åºå1ç空åå
å为紫è²äº
å
å°åºå1è¿ååå
为æ è²ï¼ï¼åºå1æé¨ååå
æ空åå
æé¢è²ï¼æ以å
è¿å为æ è²ï¼
2ãå é¤åºå2ç¸åçï¼è§çº¢è²ç¤ºï¼
3ãåºå1ç¸åçå¡«å
ç´«è²ï¼è§ç´«è²ç¤ºï¼
追çSub xx()
Set d1 = CreateObject("scripting.dictionary")
Set d2 = CreateObject("scripting.dictionary")
With [AF666:AO866]
.Interior.ColorIndex = xlNone
For i = 1 To .Count
If .Item(i) <> "" Then d1(.Item(i).Text) = ""
Next
End With
With [A39:J1038]
For i = 1 To .Count
If d1.exists(.Item(i).Text) Then
d2(.Item(i).Text) = ""
.Item(i).ClearContents
End If
Next
End With
With [AF666:AO866]
For i = 1 To .Count
If d2.exists(.Item(i).Text) Then
.Item(i).Interior.ColorIndex = 7
End If
Next
End With
End Sub