第1个回答 2013-03-05
Sub AAA()
Dim I As Long
I = Range("B65536").End(xlUp).Row
Range("C1") = "=A1*B1" '设置公式
Range("C1").Copy Range("C1" & ":C" & I) '复制公式
Range("C1" & ":C" & I).Copy '复制,然后选择性粘贴
Range("C1" & ":C" & I).PasteSpecial Paste:=xlPasteValues
Range("C" & I + 1).Value = Application.WorksheetFunction.Sum(Range("C1" & ":C" & I))‘求和
End Sub
第2个回答 2013-03-05
sub xxx()
i=1
do while cells(i,2)<>""
cells(i,3)=cells(i,1)*cells(i,2)
t = t +cells(i,3)
i=i+1
loop
cells(i,3)=t
end sub本回答被提问者采纳