vlookup only in a cell when the row is selected

[VbaHell]

Hello all

I am trying to complete a Vlookup in column "AB" but only on the active row you select and then run a macro

This is the line I added to my macro but it's not correct

[Contact = Range("AB" & ActiveCell.Row).FormulaR1C1 = "=VLOOKUP(RC[-14],'Site Names'!C[-26]:C[-25],2,FALSE)"]

Any ideas please to correct this so that it works

 

[Macropod]

This is a duplicate of: https://www.mrexcel.com/forum/excel...okup-active-line-post4933516.html#post4933516

Per forum rule 12 (http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html), kindly don't post duplicate questions.

Thread closed. You may continue the discussion in your original thread.