VBA Syntax For Dynamic Formula Statement For a Range of Cells

[Ark68]

Hello,

I am struggling with the syntax of the following line in red ...

With ws_srcdata
        src_lrow = .Cells(Rows.Count, 7).End(xlUp).Row
        src_rowcnt = src_lrow - 1
    
    
    'populate calculated columns
    
        For r = 2 To src_lrow
             'Z - Net Use Hours
            .Cells(r, 26).Formula = "= $Y$" & r & "$E$" & r"
        Next r
            
    End With
End Sub

I am trying to populate column Z from row 2 to the end of the database with dynamic formula equivalent to cells(r,"Z")=cells(r,"Y") + cells(r,"E")

 

[Fluff]

How about

Sub Ark68()
    With ws_srcdata
        .Range("Z2:Z" & .Range("G" & Rows.Count).End(xlUp).Row).FormulaR1C1 = "=rc[-1]+rc[-21]"
    End With
End Sub