- Function cz(rng As Range) '函数法
- arr = rng
- For i = 1 To UBound(arr)
- cz = cz + Val(arr(i, 1)) * Val(arr(i, 2))
- Next
- End Function
- Sub 计算() '数组直接计算
- arr = [a1].CurrentRegion
- For i = UBound(arr) To 2 Step -1
- s = s + Val(arr(i, 4)) * Val(arr(i, 5))
- If arr(i, 1) <> "" Then arr(i, 7) = s: s = 0
- Next
- [g1].Resize(UBound(arr)) = Application.Index(arr, , 7)
- End Sub
复制代码 |