Array does not pass Macro Debugging

[FWM]

I am very new to array formulas and macros. The following array works exactly the way I need it to:

 =IFERROR(INDEX(Manning!B$2:B$200,SMALL(IF(Manning!$C$2:$C$200=$A$1,ROW(Manning!B$2:B$200)-ROW(Manning!B$2)+1),ROWS(Manning!B$2:Manning!B2))),"")

When I try to use the same array in the following Macro it will not pass Debugging

Sub Refresh()
    
    Dim r As Long
    
    For r = 3 To 53
        
        Sheet8.Cells(r, 1).FormulaArray =_ "=IFERROR(INDEX(Manning!B$2:B$200,SMALL(IF(Manning!$C$2:$C$200=$A$1,ROW(Manning!B$2:B$200)-ROW(Manning!B$2)+1),ROWS(Manning!B$2:Manning!B14))),"")"
    
    Next r

End Sub

What I want to accomplish is instead of having the array in each cell run the macro as needed and have it populate cells 3-53 in Column A with the data found in the Manning worksheet.

I am new to this and any and all help is greatly appreciated.