Your code
To be changed asRange("B2:B" & LastRow).FormulaR1C1 = "= VLOOKUP(A2,Reference!A:B,2,0)"
Range("B2:B" & LastRow).Formula = "= VLOOKUP(A2,Reference!A:B,2,0)"
Your code
To be changed asRange("B2:B" & LastRow).FormulaR1C1 = "= VLOOKUP(A2,Reference!A:B,2,0)"
Range("B2:B" & LastRow).Formula = "= VLOOKUP(A2,Reference!A:B,2,0)"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks