Problem Adding formulas in different cells with VBA

[Espino2606]

Hey! I want to add formulas to various cells in excel with VBA , the first two work really well , but in the third (bicipital) I always get a error saying that there is an error with the formula
I have tried copying and pasting the first line that works and changing the name , still doesn't wort

Sub AntroHCcom()
Sheets("Deportes en Especifico").Select
Range("O61").FormulaArray = "=IFERROR(INDEX(Historial[[Tricipital ]],MATCH(R56,Historial[Suma Nom y Med],0)),"""")"
Range("O62").FormulaArray = "=IFERROR(INDEX(Historial[[Subescapular ]],MATCH(R56,Historial[Suma Nom y Med],0)),"""")"
Range("O63").FormulaArray = "=IFERROR(INDEX(Historial[[Bicipital ]],MATCH(R56,Historial[Suma Nom y Med],0)),"""")"
Range("O64").FormulaArray = "=IFERROR(INDEX(Historial[[Supracrestal ]],MATCH(R56,Historial[Suma Nom y Med],0)),"""")"
Range("O65").FormulaArray = "=IFERROR(INDEX(Historial[[Supraespinal ]],MATCH(R56,Historial[Suma Nom y Med],0)),"""")"
Range("O66").FormulaArray = "=IFERROR(INDEX(Historial[[Abdominal ]],MATCH(R56,Historial[Suma Nom y Med],0)),"""")"
Range("O67").FormulaArray = "=IFERROR(INDEX(Historial[[Muslo anterior ]],MATCH(R56,Historial[Suma Nom y Med],0)),"""")"
Range("O68").FormulaArray = "=IFERROR(INDEX(Historial[[Pantorilla ]],MATCH(R56,Historial[Suma Nom y Med],0)),"""")"

End Sub

 

[StephenCrump]

If the first two lines are working, this suggest the problem is with the table column name "Bicipital ".

Are you sure the Historial table has a column called "Bicipital "? This need to be an exact match, including the single trailing space character.

 

[Michael M]

AND
Have you tried commenting out the "Bicipital " line in the code and see if the code continues ??