请教老师,I列等于G列+H列,我用下面的VBA生成时,把I列前面的有公式列的公式全部转化为数值了,请教怎么修改? Sub 合同动态结算金额求和() Worksheets("合同明细").Range("i4:i2000").ClearContents arr = [a1].CurrentRegion For i = 4 To UBound(arr) S = 0 For j = 7 To 8 If IsNumeric(arr(i, j)) Then S = S + arr(i, j) Next arr(i, 9) = S Next [a1].CurrentRegion = arr End Sub
用下面的VBA求和时,行很多时计算超慢 Sub 合同动态结算金额求和1() Dim lastrA%, i lastrA = Sheets("合同已付明细").Cells(Rows.Count, 2).End(xlUp).Row For i = 4 To lastrA Cells(i, 9) = Application.Sum(Range(Cells(i, 7), Cells(i, 8))) Next i
End Sub
|