O
Office_Novice
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.
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.