|
请问这是怎么在循环呀,谁给讲讲哦
Sub 汇总()
'定义循环变量
Dim i As Integer
Dim j As Integer
Dim TotalRows As Integer
Dim TotalColumns As Integer
'获取当前区域的总行数
TotalRows = Worksheets("Sheet1").Range("A1"). _
CurrentRegion.Rows.Count
TotalColumns = Worksheets("Sheet1").Range("A1").CurrentRegion. _
Columns.Count
For j = 2 To TotalColumns
Cells(TotalRows, j).Value = 0
For i = 4 To TotalRows - 1
Cells(TotalRows, j).Value = Cells(i, j).Value + _
Cells(TotalRows, j).Value
Next i
Next j
End Sub
本帖最后由 zjdh 于 2012-4-3 13:07 编辑
For j = 2 To TotalColumns '从第二列到最后一列循环
Cells(TotalRows, j).Value = 0 '数据区每列的最后一单元清除为“0”
For i = 4 To TotalRows - 1 '数据区每列从第4行到最后一单元的上一单元循环
Cells(TotalRows, j).Value = Cells(i, j).Value + _ '该列各单元累加到最后一单元
Cells(TotalRows, j).Value
Next i
Next j
|
|