VLookup with a variable

[clares]

Hi All

I have a vlookup but want to include a variable in part of the formula but I can figure our where the &'s should go!

ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],Logs!R2C1:R3173C2,2,FALSE)"

The part "R3173" I would like to replace with a variable (LogsLastRow)

Any help appreciated

 

[CharlesChuckieCharles]

try

ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],Logs!R2C1:" & LogsLastRow & ",2,FALSE)"

 

[clares]

Thank you very much indeed, just required a slight tweak:

ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],Logs!R2C1:R" & LogsLastRow & "C2,2,FALSE)"