Excel VBA FormulaR1C1 Error 1004

[Squareroot]

Hi,
I am getting 1004 error for the following code, i have checked through many time and still unsure why..

ActiveCell.FormulaR1C1 = "=IF(" & buffer2(0) & "=""yes"",IF(" & buffer2(1) & "=0," _
& buffer2(2) & "*0.07,SUMPRODUCT(" & buffer2(1) & "," & buffer2(3) & ") * 0.07),0)"

 

[Squareroot]

What happened when you used my suggestion to replace buffer2(1) with buffer2(1).Address(,,xlR1C1)

It gives me following result:
=IF($H$2="yes",IF($I$2=0,SUMPRODUCT($F$2,$J$2) * 0.07,SUMPRODUCT($I$2,$J$2) * 0.07),0)
which is similar to what i wanted. i just did some modification to the code to remove the $ sign.

 

[mikerickson]

To control the $, you adjust the first two arguments of .Address

 

[Squareroot]

To control the $, you adjust the first two arguments of .Address

It works, thank you for the suggestion.