Unable to set the FormulaArray property of the range class

Hi

I keep getting this error message :
Runtime error 1004
Unable to set the FormulaArray property of the range class

...when trying to create a macro of this formula

Please Login or Register  to view this content.

here is the code in VBA

Please Login or Register  to view this content.

Could someone help me resolve this please?