Hello all
I am new to VBA, I am trying to learn it.
First thing I have tried was fail, please kindly advise
Thank you in advance
I am new to VBA, I am trying to learn it.
First thing I have tried was fail, please kindly advise
Code:
Sub Learning
Cells(6, 11) = Application.WorksheetFunction.Sumproduct((Sheet2.Range("A2:A10") = Range("B6")) * (Sheet2.Range("B1") = Range("K5")) * Sheet2.Range("B2:B10"))
End Sub