Hi,

You cannot pass an array to a formula string in that way, but you should be able to pass the arrays to the worksheetfunction
formula2 = Application.worksheetfunction.sumproduct(r2, r3, r4, r5, r6, r7)