|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 dsmch 于 2012-11-13 20:59 编辑
- Dim arr, brr(1 To 3 ^ 5 * 4, 1 To 5)
- arr = Range("a1").CurrentRegion
- For a = 1 To 3
- For b = 1 To 3
- For c = 1 To 3
- For d = 1 To 3
- x = arr(a, 1) & "," & arr(b, 2) & "," & arr(c, 3) & "," & arr(d, 4)
- For e = 1 To 3
- For f = 1 To 4
- If InStr("," & x & "," , "," & arr(e, f) & ",") = 0 Then
- s = s + 1
- y = Split(x & "," & arr(e, f), ",")
- Cells(s, 7).Resize(1, 5) = y
- End If
- Next f, e, d, c, b, a
- With Range("g1").CurrentRegion
- .Value = .Value
- End With
复制代码 |
|