|
发表于 2013-10-4 11:19
|
显示全部楼层
本楼为最佳答案
mhyjcm8888 发表于 2013-10-4 10:16
能否帮忙修改一下,谢谢!!! - Sub abc()
- Set d = CreateObject("scripting.dictionary")
- Set d1 = CreateObject("scripting.dictionary")
- For i = 1 To Sheets.Count - 1
- kk = Sheets(i).Range("a15").CurrentRegion
- For j = 1 To UBound(kk, 2)
- s = Join(Application.Transpose(Application.Index(kk, 0, j)))
- d1(s) = ""
- Next j
- pp = d1.keys
- d1.RemoveAll
- For j = 0 To UBound(pp)
- d(pp(j)) = d(pp(j)) + 1
- If d(pp(j)) = Sheets.Count - 1 Then
- Cells(1, m + 1).Resize(4, 1) = Application.Transpose(Split(pp(j), " "))
- m = m + 1
- End If
- Next j
- Next i
- End Sub
复制代码 |
|