谢谢“dsmch ”老师的帮助!能解惑一下下面的代码意思吗?这样我可以按照老师的意思做了!!谢谢!!!
For i = Cells(110, j).End(xlUp).Row To 110 - n
Set Rng = Cells(i, j).Resize(k - 110, 1)
If Application.CountIf(Rng, Cells(i, j)) = k - 110 Then
s = s + 1: p = p & "," & LCase(Rng(1).Address(0, 0)) & "`" & LCase(Rng(Rng.Count).Address(0, 0))
End If
Next