vba entering a R1C1 formula

[gtd526]

Hello,
I'm trying to enter a formula using R1C1 formula, but Im receiving an error. The Row will adjust to the cell Im entering the formula.
Its referring to another workbook/worksheet.
Here is the formula Im trying to enter:
Selection.FormulaR1C1 = "=IF(RC12="","",SUMIFS([NBA.xlsm]Favs!R7C44,R142C64,[NBA.xlsm]Favs!$R5C40,R140C60,RC12))"

Thank you.

 

[MARK858]

You need to double up your quotes

=IF(RC12="""","""",SUMIFS([NBA.xlsm]Favs!R7C44,R142C64,[NBA.xlsm]Favs!$R5C40,R140C60,RC12)

 

[gtd526]

You need to double up your quotes

=IF(RC12="""","""",SUMIFS([NBA.xlsm]Favs!R7C44,R142C64,[NBA.xlsm]Favs!$R5C40,R140C60,RC12)

I made the correction, but still receive an error:
code im using:

Range("P100000").End(xlUp).Select
        Range(Selection, Selection.End(xlUp)).Select
'        Selection.FormulaR1C1 = "=IF(RC12="","",SUMIFS([NBA.xlsm]Favs!R7C44,R142C64,[NBA.xlsm]Favs!$R5C40,R140C60,RC12))"
        Selection.FormulaR1C1 = "=IF(RC12="""","""",SUMIFS([NBA.xlsm]Favs!R7C44,R142C64,[NBA.xlsm]Favs!$R5C40,R140C60,RC12)"

I also modified the ")" and the end to "))" but received the same error.

 

[MARK858]

Post your formula that you put in the cell manually.

 

[Fluff]

Try

        Selection.FormulaR1C1 = "=IF(RC12="""","""",SUMIFS([NBA.xlsm]Favs!R7C44:R142C64,[NBA.xlsm]Favs!R5C40:R140C60,RC12))"

 

[gtd526]

Try

        Selection.FormulaR1C1 = "=IF(RC12="""","""",SUMIFS([NBA.xlsm]Favs!R7C44:R142C64,[NBA.xlsm]Favs!R5C40:R140C60,RC12))"

It works. Good catch, the "$".
Thank you.

 

[gtd526]

Post your formula that you put in the cell manually.

Thanks for the double-quotes.

 

[Fluff]

Glad we could help & thanks for the feedback.