VBA 1004 Error - Embed formula into cell

[JJCA99]

Hello,

I have what seems like an easy fix but for whatever reason i'm getting the application/object defined error from the formula below.

fyi: I want to embed this formula into each cell so that anyone who uses the wb after me can see the formula used.

      With Range("Q6:Q" & Cells(Rows.Count, 2).End(xlUp).Row)
        .Formula = "=IF($Z6<=R$5,0,IF(AND($O6>$N6,R$5<$O6,$AA6<>0),SUMIFS(Maint_Summ!$AA:$AA,Maint_Summ!$D:$D,'SE CAPACITY'!$E6,Maint_Summ!$W:$W,'SE CAPACITY'!$C6),0)"
 
    End With

 

[JJCA99]

Please Disregard this thread I found the error. I was missing a parenthesis on the end of the formula.