Ayuda con esta Formula de Excel

Buenas tardes Expertos molestándolos nuevamente, me podrían explicar por que esta formula que se realizo en esta celda funciona perfectamente:

=SI.ERROR(INDICE('Business Service'!$1:$1048576,COINCIDIR(Circuit!$I:$I,'Business Service'!$Z:$Z,0),COLUMNA('Business Service'!$AJ:$AJ)),SI.ERROR(INDICE('Business Service'!$1:$1048576,COINCIDIR(Circuit!$I:$I,'Business Service'!$AA:$AA,0),COLUMNA('Business Service'!$AJ:$AJ)),SI.ERROR(INDICE('Business Service'!$1:$1048576,COINCIDIR(Circuit!$I:$I,'Business Service'!$AB:$AB,0),COLUMNA('Business Service'!$AJ:$AJ)),SI.ERROR(INDICE('Business Service'!$1:$1048576,COINCIDIR(Circuit!$I:$I,'Business Service'!$AC:$AC,0),COLUMNA('Business Service'!$AJ:$AJ)),SI.ERROR(INDICE('Business Service'!$1:$1048576,COINCIDIR(Circuit!$I:$I,'Business Service'!$AD:$AD,0),COLUMNA('Business Service'!$AJ:$AJ)),SI.ERROR(INDICE('Business Service'!$1:$1048576,COINCIDIR(Circuit!$I:$I,'Business Service'!$AE:$AE,0),COLUMNA('Business Service'!$AJ:$AJ)),SI.ERROR(INDICE('Business Service'!$1:$1048576,COINCIDIR(Circuit!$I:$I,'Business Service'!$AF:$AF,0),COLUMNA('Business Service'!$AJ:$AJ)),SI.ERROR(INDICE('Business Service'!$1:$1048576,COINCIDIR(Circuit!$I:$I,'Business Service'!$AG:$AG,0),COLUMNA('Business Service'!$AJ:$AJ)),SI.ERROR(INDICE('Business Service'!$1:$1048576,COINCIDIR(Circuit!$I:$I,'Business Service'!$AH:$AH,0),COLUMNA('Business Service'!$AJ:$AJ)),INDICE('Business Service'!$1:$1048576,COINCIDIR(Circuit!$I:$I,'Business Service'!$AI:$AI,0),COLUMNA('Business Service'!$AJ:$AJ)))))))))))

Y al quererla grabar en una macro queda de la siguiente manera:

ActiveCell.FormulaR1C1 = _ "=IFERROR(INDEX('Business Service'!R1:R1048576,MATCH(Circuit!C9,'Business Service'!C26,0),COLUMN('Business Service'!C36)),IFERROR(INDEX('Business Service'!R1:R1048576,MATCH(Circuit!C9,'Business Service'!C27,0),COLUMN('Business Service'!C36)),IFERROR(INDEX('Business Service'!R1:R1048576,MATCH(Circuit!C9,'Business Service'!C28,0),COLUMN('Business Service'!C36)),IFERROR" & _ "Business Service'!R1:R1048576,MATCH(Circuit!C9,'Business Service'!C29,0),COLUMN('Business Service'!C36)),IFERROR(INDEX('Business Service'!R1:R1048576,MATCH(Circuit!C9,'Business Service'!C30,0),COLUMN('Business Service'!C36)),IFERROR(INDEX('Business Service'!R1:R1048576,MATCH(Circuit!C9,'Business Service'!C31,0),COLUMN('Business Service'!C36)),IFERROR(INDEX('Business" & _ "!R1:R1048576,MATCH(Circuit!C9,'Business Service'!C32,0),COLUMN('Business Service'!C36)),IFERROR(INDEX('Business Service'!R1:R1048576,MATCH(Circuit!C9,'Business Service'!C33,0),COLUMN('Business Service'!C36)),IFERROR(INDEX('Business Service'!R1:R1048576,MATCH(Circuit!C9,'Business Service'!C34,0),COLUMN('Business Service'!C36)),INDEX('Business Service'!R1:R1048576,MAT" & _ "t!C9,'Business Service'!C35,0),COLUMN('Business Service'!C36)))))))))))"

ActiveCell.AutoFill Destination:=Range("C" & ActiveCell.Row & ":C" & Range("H1048576").End(xlUp).Row), Type:=xlFillDefault

Y si lo hace pero al quererla correr manda error de depuración... Sera que es muy pesada y existe alguna forma de reaparar esto, saludos cordiales..