Runtime Error 1004 with Arrayformula

Hey all,

The following code keeps on giving an error
"Unable to set the FormulaAray property of the range class"

Range("AG2").FormulaArray = "=SUM(IF(WERKBLAD!R[2]C[-29]:R[2]C[223]=RC[-1],IF(WERKBLAD!R[4]C[-31]:R[998]C[-31]>=RC[-3],IF(WERKBLAD!R[4]C[-31]:R[998]C[-31]<=RC[-2],IF(WERKBLAD!R[4]C[-29]:R[998]C[223]=""V"",1)))))+SUM(IF(WERKBLAD!R[2]C[-29]:R[2]C[223]=RC[-1],IF(WERKBLAD!R[4]C[-31]:R[998]C[-31]>=RC[-3],IF(WERKBLAD!R[4]C[-31]:R[998]C[-31]<=RC[-2],(WERKBLAD!R[4]C[-29]:R[998]C[223])))))/8"

Could it be because of the length and if so, is there a solution?

Please reply to this question:

http://www.excelforum.com/excel-prog...condition.html

Originally Posted by StephenR

Please reply to this question:

http://www.excelforum.com/excel-prog...condition.html

Oops, I forgot to repy that one.

Anyone.............?