Hi Guys, I am doing a macro and I want to copy and paste append down column D in an Excel tab and inserts a lookup formula where it concatenates the values 3 cells left and 2 cells left of the Cursor thus
=VLOOKUP(RC[-3]&RC[-2]. The range I want to look up is 3 columns to the right (column G) , 15 rows down and finishes in column I.
For example, my cursor is at Range ("D648"), my formula will be =vlookup (RC[-3]&RC[-2], R648C7:R662C9,2,False). How do I make this lookup range variable in VB code?