|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub zz()
- Dim a, b, c%(), r%, rr%, cc%, x%, y%
- a = Split("p,o,q,u,v,x", ",")
- ReDim c%(UBound(a))
- For i = 0 To UBound(a)
- c(i) = Columns(a(i)).Column
- Next
- a = Sheets(1).[a9].CurrentRegion.Value
- b = Sheets(2).[a1:n49].Value
- x = 5: y = 3: r = 9
- For ii = 2 To UBound(a) - 1
- For i = 0 To x - 1
- rr = i * r + 2 + i
- For j = 0 To y - 1
- cc = j * x + 2
- For n = 0 To UBound(c)
- b(rr + n, cc) = a(ii, c(n))
- Next
- Next
- Next
- Next
- Sheets(2).Copy
- [a1].Resize(UBound(b), UBound(b, 2)) = b
- End Sub
复制代码 |
|