Search code examples
excelvbavlookup

Insert VLOOKUP into cell with VBA

I cannot seem to get this to work. I want to put this vlookup formula into cell B10, looking up A10, but it gives me a NAME? value every time, as it comes out as 'A10' in the actual formula, instead of A10. Can anyone help? Here's my code:

    Range("B10").Select
    ActiveCell.FormulaR1C1 = "=VLOOKUP(A10,'Sheet2'!A:B,2,0)"
Solution

  • as @scottCraner said, you need it in this format:

    Range("B10").Select
ActiveCell.Formula = "=VLOOKUP(A10,'Sheet2'!A:B,2,0)"