Posts by Mariannu

    Hi guys i noticed this is an old post but still maybe someone can find this useful:

    The code should have this form: if you want to use all the values from a specific column just replace Range("K20:K200") with Columns("K:K")

    MsgBox Application.WorksheetFunction.SumProduct(Range("K20:K200"), Range("H20:H200"), Range("I20:I200"))

    This is all the code you need.