Macro to insert an IF statement and copy it down to the last row in a column

[tsherv]

I'd like to create a macro that inserts the following IF statement into cell S3, and copy it down the S column to the last row of data. I have a formula that works for simple calculations, but I can't get it working with my IF statement. Here's what I'm currently doing:

Sub FormulaFill()
Dim LastRowColumnA As Long
LastRowColumnA = Cells(Rows.Count, 1).End(xlUp).Row
Range("W3:W" & LastRowColumnA).Formula = "=IF(T3="","",IF(R3=1,1,IF(V3=0,N2,IF(T3<>"",T3&"SS"&ROUNDUP(U3,0),""))))"
End Sub

My IF statement works fine if I manually insert it and drag it down. Any idea why this won't work?

 

[Fluff]

You need to double-up on the quotes inside the formula.

 

[tsherv]

Thanks again. Worked great.

 

[Fluff]

Glad to help & thanks for the feedback.