|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub gj23w98()
- ReDim brr(1 To 9999, 1 To 15)
- arr = [b7].CurrentRegion
- For i = 1 To UBound(arr)
- m = m + 1
- s = Array(arr(i, 10), arr(i, 3), arr(i, 7), arr(i, 5), arr(i, 6), arr(i, 14), arr(i, 15), arr(i, 9), _
- arr(i, 1) & arr(i, 2), arr(i, 12), arr(i, 13), arr(i, 16), arr(i, 17), arr(i, 8), arr(i, 18))
- For j = 0 To UBound(s)
- brr(m, j + 1) = s(j)
- Next
- t = t + Val(brr(m, 7))
- Next
- brr(m + 1, 1) = "合计": brr(m + 1, 7) = t
- With Sheets("B1表")
- If m Then
- .Cells.Clear
- .Columns(4).NumberFormatLocal = "@"
- .[a1].Resize(m + 1, 15) = brr
- .[a1].Resize(m + 1, 15).Borders.LineStyle = 1
- End If
- End With
- End Sub
复制代码 |
|