i = 5
"=SUMPRODUCT(B" & i & ":E" & i & "{1,3,2,3})"

"Office_Novice" wrote:

Here is what i have

buttonClick()
'ommited defined variables and other useless stuff

CurrentSheet.Cells(CurrentRow, 6).Formula = "=SUMPRODUCT(B2:E2{1,3,2,3})"

What i would like is the range in the formula to increase as the Current row
increases so =SUMPRODUCT(B3:E3{1,3,2,3}) and so on down the table

In Short the 6th column of every row needs a SUMPRODUCT function for the 3rd
through 5th coulmn

i think i have to define a variable but not sure here.

Somthing like =SUMPRODUCT(B(i):E(i){1,3,2,3}) maybe?
any help would be great.