VBA 問題 Application.WorksheetFunction.SumProduct(A1:A6, B1:B6) 出現錯誤,請教正確寫法.?
回答 (1)
2015-08-30 4:01 pm
Sub xx()
Cells(1, 3) = Application.SumProduct([A1:A6], [B1:B6])
End Sub
Cells(1, 3) = Application.SumProduct([A1:A6], [B1:B6])
End Sub
收錄日期: 2021-05-04 01:59:55
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20150829180534AA3wCIr