|
另外,求助宏的话,起码应该上传个xlsm的文件,方便答疑的人- Sub a()
- Dim i&, j&, arr, brr, m&, n&, crr(), s&, dic As Object
- Set dic = CreateObject("scripting.dictionary")
- arr = Sheets("数据").Range("c2:h" & Sheets("数据").Cells(Rows.Count, 1).End(3).Row)
- brr = Sheets("内容").Range("c2:c" & Sheets("内容").Cells(Rows.Count, 1).End(3).Row)
- For i = 1 To UBound(brr)
- n = 0
- For j = 1 To UBound(arr)
- For m = 1 To UBound(arr, 2)
- If arr(j, m) <> "" Then
- If brr(i, 1) Mod arr(j, m) = 0 Then
- n = n + 1
- ReDim Preserve crr(1 To n)
- crr(n) = arr(j, m)
- End If
- End If
- Next
- Next
- For s = 1 To UBound(crr)
- dic(crr(s)) = ""
- Next
-
- Sheets("内容").Cells(i + 1, 5) = Join(dic.keys, ",")
-
-
- dic.RemoveAll
- Next
- Set dic = Nothing
- End Sub
复制代码 |
|