worksheetFunction Sumproduct

[Xceller]

Hi everyone - need a second set of eyes to look at this. Appreciate your help.
error out on the last line of code
v = Error2029

Please Login or Register  to view this content.

[harrisonland]

You're passing VBA variables to the Sumproduct worksheet function as if they're meaningful in the worksheet.

I'd try

Please Login or Register  to view this content.

Tim

[MarvinP]

Hey Tim,

I thought you shouldn't put the "=" in your formula. Hope the OP gets back and shows us what worked.
This video says no equal sign needed. https://www.youtube.com/watch?v=UFTObyf_Flg

[harrisonland]

Hey Tim,

I thought you shouldn't put the "=" in your formula. Hope the OP gets back and shows us what worked.

Well, actually I thought you were right, then I tried this in a blank workbook:

Please Login or Register  to view this content.

[MarvinP]

Did both work or only the second? This vid shows both ways:
https://www.youtube.com/watch?v=CdQJqT_9uf4&t=210s

[harrisonland]

Did both work or only the second?

Both - with the correct answer.

[MarvinP]

My Post two above shows a video saying both work.

[Xceller]

Hi harrisonland , Thanks for looking into this, but it says :" Type mismatch"

[harrisonland]

Does it work in-cell if you replace the variables with their respective values? Error 2029 is equivalent to #NAME....

Need to see the worksheet, really.

Tim

[protonLeah]

rngMasterID.adddress?