|
- Sub 数组方法()
- Dim arrSrc, arrRst()
- Dim iCol%, iRow%
- Dim temSum%
- arrSrc = Range("a11:f18").Value
- ReDim arrRst(1 To UBound(arrSrc), 1 To 1)
- For iRow = 1 To UBound(arrSrc)
- For iCol = 1 To UBound(arrSrc, 2)
- temSum = temSum + arrSrc(iRow, iCol)
- Next
- arrRst(iRow, 1) = temSum
- temSum = 0
- Next
- Range("h11").Resize(UBound(arrSrc)) = arrRst
- End Sub
复制代码- Option Explicit
- Sub 字典法()
- Dim objdic As Object
- Dim arrSrc
- Dim iRow%, iCol%
- Dim temSum%
- arrSrc = Range("a11:f18").Value
- Set objdic = CreateObject("scripting.dictionary")
- For iRow = 1 To UBound(arrSrc)
- For iCol = 1 To UBound(arrSrc, 2)
- temSum = temSum + arrSrc(iRow, iCol)
- Next
- If Not objdic.exists(iRow) Then
- objdic.Add iRow, temSum
- End If
- temSum = 0
- Next
- Range("i11").Resize(objdic.Count) = Application.Transpose(objdic.items)
- End Sub
复制代码 |
评分
-
查看全部评分
|