correct syntax for replacing a number with a variable in VBA

[geewhysee]

I have this macro

LastRow = Cells(Rows.Count, "E").End(xlUp).Row


Range("F2").FormulaArray = "=IF(C2=""Job complete"",(D2+E2)-SUM(VLOOKUP(B2&"" - Job assigned/passed"",$A$1:[COLOR=#ff0000]$E$62[/COLOR],{4;5},0)),"""")" 'Insert Array
Range("F2").AutoFill Destination:=Range("F2:F" & LastRow), Type:=xlFillDefault

and I want to replace the 62 in $E$62 with LastRow. I know I need to use & and "" in some configuration but rather than trial and error for an hour or two I thought I'd ask here.

 

[MARK858]

Try...

Range("F2").FormulaArray = "=IF(C2=""Job complete"",(D2+E2)-SUM(VLOOKUP(B2&"" - Job assigned/passed"",$A$1:$E$" & LastRow & ",{4;5},0)),"""")"

 

[geewhysee]

Worked perfectly, thanks friend!