|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 Chiyuen 于 2020-1-29 02:22 编辑
麻烦大神帮看下这段代码,是想在多个表内,进行同类组合求和,如果去掉最外层的For循环,把Sheets(l)改成常量,只操作一张表就没问题,但是我是想对每一张表执行命令,,不知道为什么会错,求助大神们
Sub count_test()
Dim i As Integer
Dim arrs() As Variant
i = 1
For l = 1 To Sheets.Count
irow = Sheets(l).Range("a65536").End(xlUp).Row
icolumn = Sheets(l).Range("IV1").End(xlToLeft).Column
ReDim Preserve arrs(1 To irow, icolumn - 1) '提示下标越界
For j = 1 To irow Step 1
strname = Cells(j, 1)
isfind = False
k = 0
For k = 1 To irow
If arrs(k, 0) = strname Then
isfind = True
Exit For
End If
Next k
If isfind Then
arrs(k, 1) = arrs(k, 1) + Cells(j, 2)
Else
arrs(i, 0) = Cells(j, 1)
arrs(i, 1) = Cells(j, 2)
i = i + 1
End If
Next j
For k = 1 To irow
If arrs(k, 0) <> "" Then
Cells(k, 4) = arrs(k, 0)
Cells(k, 5) = arrs(k, 1)
End If
Next k
Next
End Sub
|
|