|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub 矩形圆角1_Click()
- Set d = CreateObject("scripting.dictionary")
- r = 0
- arr = [g1].CurrentRegion
- For j = 5 To UBound(arr)
- For i = 8 To UBound(arr, 2) Step 5
- If d.exists(arr(j, 2) & arr(j, 3)) Then
- arr(d(arr(j, 2) & arr(j, 3)), 3) = arr(j, i) + arr(d(arr(j, 2) & arr(j, 3)), 3)
- Else
- r = r + 1
- d(arr(j, 2) & arr(j, 3)) = r
- arr(r, 1) = arr(j, 2)
- arr(r, 2) = arr(j, 3)
- arr(r, 3) = arr(j, i)
- End If
- Next i
- Next j
- [a6].Resize(r, 3) = arr
- End Sub
复制代码 |
|