FormulaArray with variable

[Konrado]

Sub GLO()


Hi, I want to use variable in my FormulaArray, but it doesn't work. If you know how to do it, please help me. Below code:

Dim LastRowFinal As Long


LastRowFinal = Worksheets("DATA").Range("A" & Rows.Count).End(xlUp).Row


Worksheets("View").Activate


TempString = "=SUM((R4C5=DATA!R4C4:R" & LastRowFinal & "C4)*(IF(R5C5<>""TOTAL"",R5C5=DATA!R4C5:R" & LastRowFinal & "C5,1))*(RC3=DATA!R4C14:R" & LastRowFinal & "C14)*(RC4=DATA!R4C12:R" & LastRowFinal & "C12)*(R11C=DATA!R2C19:R2C66)*(CHOOSE(R218C6,R218C8=DATA!R3C19:R3C66,R218C8>=DATA!R3C19:R3C66,R218C8<DATA!R3C19:R3C66))*(DATA!R4C19:R" & LastRowFinal & "C66))"


Worksheets("View").Range("E14").FormulaArray = TempString


End Sub