Unable to set the ForumulaArray property of the Range class help

[Jyrka]

Hi

I am trying to insert formula to my cell by vba it compaers two cells and then calculates third value which has same values

.Range("K" & RowNumber).FormulaArray = "=SUM((F5:F1535)*(C5:C1535=C' [" & RowNumber & "]')*(B5:B1535=B' [" & RowNumber & "]'))"

But i get the following error '1004' Unable to set the ForumulaArray property of the Range class help

can somebody say what i am doing wrong

 

[Jyrka]

Hi

I have managed to fix it my šelf

.Range("K" & RowNumber).FormulaArray = "=SUM((F5:F1535)*(C5:C1535=C" & RowNumber & ")*(B5:B1535=B" & RowNumber & "))"

Hope this helps somebody else