|
把原先的改改。多单元格要和数据源单元格列数相同。
- Option Explicit
- Function BCFSJ(ParamArray vntAreas() As Variant) As Variant()
- Dim NotRepeat As Object, vntArea, vntElement
- Dim lngCounter&, vntRslt(), A&, vntKey
- Set NotRepeat = CreateObject("Scripting.Dictionary")
- For Each vntArea In vntAreas
- For Each vntElement In vntArea
- lngCounter = lngCounter + 1
- If TypeName(vntElement) = "Range" Then
- If vntElement <> "" Then NotRepeat(vntElement.Value) = ""
- Else
- NotRepeat(vntElement) = ""
- End If
- Next
- Next
- ReDim vntRslt(lngCounter - 1, 0)
- For Each vntKey In NotRepeat.keys
- vntRslt(A, 0) = vntKey
- A = A + 1
- Next
- While A < lngCounter
- vntRslt(A, 0) = ""
- A = A + 1
- Wend
- BCFSJ = vntRslt
- End Function
复制代码
|
评分
-
1
查看全部评分
-
|