gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 657
- Office Version
- 2019
- Platform
- Windows
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.
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.