End of statement Error on If Statement in Macro

[CVBASIMON]

Hi all

I am trying to create an if statement within a copy paste pertaining to a rwo of data, when I add in the "SA" at the end the VBA editor comes up with a "Compile Error: Expected : End of statement: does anyone know how I could get around this?

Code:
'creating document types
FinalRow = Cells(Rows.Count, "C").End(xlUp).Row
Range("B2:B2" & FinalRow).Formula = "=if(C2="""","""","SA")"
Range("B2").Copy Destination:=Range("B2" & FinalRow)

 

[Jonmo1]

You need to double up ALL the quotes..
You started to with the C2="" part, you cahnged to C2=""""

But you need to do it on the "SA" part as well, that should be ""SA""

 

[CVBASIMON]

You need to double up ALL the quotes..
You started to with the C2="" part, you cahnged to C2=""""

But you need to do it on the "SA" part as well, that should be ""SA""

To Easy! Thank you for your quick response.