Type Mismatch

[gtd526]

Hello,
Receiving this error on entering a R1C1 formula:
Here is the code:

Sub Test10()
'betting Team Non-Parlay
    LastRow = Cells(Rows.Count, "B").End(xlUp).Row      'last row according to "B"
    Range("E" & LastRow).Select  'have to SELECT lastRow to select correct range regarding line below
    Selection.Offset(0, 3).Select
'    Range(Selection, Selection.End(xlDown)).Select 'select ALL moving Down
'insert formula
    ActiveCell.FormulaR1C1 = "=LOOKUP(2, 1/((COUNTIF(R[-1]C8:RC8, '[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)"

End Sub

Thank you.

 

[Joe4]

With all these formula issues you are having, there is a little trick you can use, to let Exceldo all the work for you.
Turn on your Macro Recorder, and record yourself entering the formula manually onto the sheet.
When you get it working correctly, stop the Macro Recorder and view your code.
Find the last line of code that has ".FormulaR1C1 = ..." in it, and copy everything after that on top of the formula that you have.
Then you should have a good working formula, as Excel wants it.

 

[Fluff]

You could also look at this thread of yours, which basically shows you how that formula should look. FormulaR1C1, cell not referring to itself error

 

[gtd526]

With all these formula issues you are having, there is a little trick you can use, to let Exceldo all the work for you.
Turn on your Macro Recorder, and record yourself entering the formula manually onto the sheet.
When you get it working correctly, stop the Macro Recorder and view your code.
Find the last line of code that has ".FormulaR1C1 = ..." in it, and copy everything after that on top of the formula that you have.
Then you should have a good working formula, as Excel wants it.

Done. Thank you.

 

[gtd526]

You could also look at this thread of yours, which basically shows you how that formula should look. FormulaR1C1, cell not referring to itself error

Thank you.

 

[Fluff]

Glad we could help.