VBA placing Vlookup formula in cell error

[gruntingmonkey]

Hello all, I need to place a formula into a cell via VBA where there are some variables but I keep getting "False" as the response rather than it pasting in the formula to the cell. Anyone have any ideas on how to rectify my code?

Cells(LastrowRat, 44).Formula = "" = " VLOOKUP(AD" & LastrowRat & ",'Rates Log'!B:L,'Rates Log'!$D$2,FALSE)"""

 

[aRandomHelper]

Cells(LastrowRat, 44).Formula = "=VLOOKUP(AD" & LastrowRat & ",'Rates Log'!B:L,'Rates Log'!$D$2,FALSE)"

 

[gruntingmonkey]

Sorry, I couldn't see the wood for the trees there....