|
发表于 2014-10-17 23:40
|
显示全部楼层
本楼为最佳答案
- Sub a()
- Dim i&, j&, dic As Object, arr, brr(), s&
- arr = [a1].CurrentRegion
- For i = 1 To UBound(arr)
- For j = 1 To 5
- If arr(i, j) <> "" Then
- s = s + 1
- ReDim Preserve brr(1 To s)
- brr(s) = arr(i, j)
- End If
- Next
- Next
- Set dic = CreateObject("scripting.dictionary")
- For s = 1 To UBound(brr)
- dic(brr(s)) = ""
- Next
- [g1].Resize(1, dic.Count) = dic.keys
- End Sub
复制代码 |
评分
-
查看全部评分
|