Hi everyone,

Can someone please tell me why I'm receiving a " 1004 - Unable to set the FormulaArray property of the Range Class " error on this:


  Range("M13").FormulaArray = "=IF($C13="""","""",IFNA(INDEX('LOG DETAILS'!$J$2:$J$20000,MATCH($C13&""SDI"",'LOG DETAILS'!$D$2:$D$20000&'LOG DETAILS'!$G$2:$G$20000,0)),IFNA(INDEX('LOG DETAILS'!$J$2:$J$20000,MATCH($C13&""Subguard"",'LOG DETAILS'!$D$2:$D$20000&'LOG DETAILS'!$G$2:$G$20000,0)),"""")))"