Incorporate LastRow into Formula

[sharky12345]

Can someone show me how I can incorporate a 'LastRow' variable into a Formula?

What I have here isn't working;

Lastrow = Range("K55").End(xlUp).Row + 1
Range("L" & Lastrow).Formula = "=VLOOKUP(K "& Lastrow",$D$8:$I$31,6,FALSE)"

 

[FormR]

Hi, remove the space after the K and add an & after Lastrow, i.e.

Range("L" & Lastrow).Formula = "=VLOOKUP(K" & Lastrow & ",$D$8:$I$31,6,FALSE)"

 

[sharky12345]

So easy when you know how!

Thanks - works a treat!