FormulaR1C1, cell not referring to itself error

[gtd526]

Hello,
The following code works, but when I Offset from another cell to the correct cell and enter the formula, I receive an error (row 48 only being entered). Thank you.
Here is the formula:

Wagers.xlsm
	A
47	With Range("H" & Rows.Count).End(xlUp)
48	.FormulaR1C1 = "=IFERROR(LOOKUP(2, 1/((COUNTIF(R" & .Row - 1 & "C8:R[-1]C8,'[NFL.xlsm]Weekly Picks'!R4C8:R35C8)=0)*('[NFL.xlsm]Weekly Picks'!R4C8:R35C8<>"""")),'[NFL.xlsm]Weekly Picks'!R4C8:R35C8),"""")"
49	End With
NFL to R1C1

 

[gtd526]

Try

ActiveCell.FormulaR1C1 = "=IFNA(LOOKUP(2, 1/((COUNTIF(R[-1]C8,'[NFL.xlsm]Weekly Picks'!R4C8:R35C8)=0)*('[NFL.xlsm]Weekly Picks'!R4C8:R35C8<>"""")*('[NFL.xlsm]Weekly Picks'!r4c6:r35c6="" * "")),'[NFL.xlsm]Weekly Picks'!R4C8:R35C8),0)"

Thank you.

 

[Fluff]

Glad we could help & thanks for the feedback.