Unable to set FormulaArray property of the Range class VBA

[bambino86]

Hi,

I have recorded a macro that formats my report automatically. However, I encounter an error when running the macro "Unable to set FormulaArray property of the Range class". Here is the code with error that i encounter with

Range("O2").Select
    Selection.FormulaArray = _
        "=IF([@Division]<>""Billing"","""",IFERROR(VLOOKUP([@Team],Table_Task_Table_reference.accdb_6,2,FALSE),IFERROR(INDEX(Table_Task_Table_reference.accdb_7[Billing Cycle],MATCH([@Office]&[@[Billing Group]],Table_Task_Table_reference.accdb_7[Office]&Table_Task_Table_reference.accdb_7[Billing Group],0)),IFERROR(INDEX(Table_Task_Table_reference.accdb_8[Billing Cycle],MATCH(" & _
        "[@Office],MATCH(Table_Task_Table_reference.accdb_8[Team]&Table_Task_Table_reference.accdb_8[Office],0))),IFERROR(INDEX(Table_Task_Table_reference.accdb_9[Billing Cycle],MATCH([@Office]&[Submitting Assistant],MATCH(Table_Task_Table_reference.accdb_9[Office]&Table_Task_Table_reference.accdb_9[Submitting Assistant],0))),""By Request"")))))"

. I don't know how to write the code for this macro to work.

I attached my report for your reference. I hope you can help me on this.