每一帖要比對的位置都不一樣
不知該回覆哪一帖
最後一帖的:
Sub module1()
Dim yy As Range, data As Range
For Each yy In Range([a1], [a65535].End(3))
Set c = [b:b].Find(yy, , , 1)
If Not c Is Nothing Then
If data Is Nothing Then
Set data = c
Else
Set data = Union(data, c)
End If
End If
Next
If Not data Is Nothing Then
With data
.Interior.ColorIndex = 3
.Offset(, 1) = "V"
End With
End If
End Sub作者: mark15jill 時間: 2011-4-28 15:24