|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
参与一下。。。
- Sub ykcbf() '//2024.6.26
- Set sh = ThisWorkbook.Sheets("Sheet1")
- st = sh.[a1].Value
- ReDim brr(1 To 1000, 1 To 2)
- For Each sht In Sheets
- If sht.Name <> sh.Name Then
- arr = sht.UsedRange
- m = m + 1
- For j = 1 To UBound(arr, 2)
- If arr(1, j) = st Then
- Sum = 0
- For i = 2 To UBound(arr)
- Sum = Sum + arr(i, j)
- Next
- brr(m, 1) = sht.Name
- brr(m, 2) = Sum
- End If
- Next
- End If
- Next
- With sh
- .[a2].Resize(1000, 2) = ""
- .[a2].Resize(m, 2) = brr
- End With
- MsgBox "OK!"
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|