Sub kljlk()
Dim i&, aa$, d As Object
Set d = CreateObject("scripting.dictionary")
aa = Application.InputBox("要查询的字符", "请输入", "小明", , , , , 2)
For i = 1 To [a65536].End(3).Row
If Cells(i, 1) = aa Then d(Cells(i + 1, 1).Value) = ""
Next
Range("B1").Resize(d.Count, 1) = Application.Transpose(d.keys)
Set ...
|