|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub test()
- Dim r%, i%
- Dim arr, brr, crr()
- With Worksheets("参数设置")
- c = .Cells(1, .Columns.Count).End(xlToLeft).Column
- brr = .Range("b1").Resize(2, c - 1)
- End With
- For j = 2 To UBound(brr, 2)
- brr(2, j) = brr(2, j - 1) + brr(2, j)
- Next
- With Worksheets("sheet1")
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- c = .Cells(1, .Columns.Count).End(xlToLeft).Column
- arr = .Range("a1").Resize(r, c)
- ReDim zrr(1 To (UBound(arr, 2) - 1) / 2, 1 To UBound(brr, 2) + 1)
- q = 0
- For j = 2 To UBound(arr, 2) Step 2
- q = q + 1
- zrr(q, 1) = arr(1, j)
- m = 0
- For i = 2 To UBound(arr)
- If Len(arr(i, j)) <> 0 Then
- m = m + 1
- ReDim Preserve crr(1 To m)
- crr(m) = arr(i, j)
- End If
- Next
- rs = UBound(crr)
- For k = 1 To UBound(brr, 2)
- zrr(q, k + 1) = Application.Large(crr, rs * brr(2, k))
- Next
- Next
- End With
- With Worksheets("参数设置")
- .Select
- With .Range("a3").Resize(UBound(zrr), UBound(zrr, 2))
- .Value = zrr
- .Interior.ColorIndex = 3
- End With
- End With
-
- End Sub
复制代码 |
|