Copying a Formula into a cell

[Dalua]

I have this Formula but when i try to add it into a cell it says Application-defined or object-defined error

This is the formula

ProgForm = "=IFERROR(INDEX('" & PathFile & Filename
ProgForm = ProgForm & "'!Division_6[Programmer],AGGREGATE(15,6,(ROW(" & PathFile & Filename
ProgForm = ProgForm & "'!Division_6[Project])-ROW('" & PathFile & "[" & Filename
ProgForm = ProgForm & "]" & "CFG'!$F$8))/('" & PathFile & Filename
ProgForm = ProgForm & "'!Division_6[Project]=$A$1),ROWS(D$7:D7))),"""")"
          
MsgBox ProgForm
End With

ActiveWorkbook.Sheets("PLC").Range("A40").Formula = ProgForm

Any Ideas,

Thanks in advance!

PD. I check the formula (Using the Msgbox) with the one that i have on the sheets and it is exactly the same