Hi Guys, I have this Formula in an Excel tab.
Range("D" & Rows.Count).End(xlUp).Offset(1).Resize(10).FormulaR1C1 = "=VLOOKUP(RC[-3]&RC[-2], RC:RC, 2,0)"
It basically loops up from the bottom of Column D to hit the first populated cell, then goes down one row and inserts a Vlookup (RC[-3]&RC[-2], RC:RC, 2,0) and resizes it for the next 10 rows. However, I want to lock in the vlookup range so it remains the same range for the next 10 rows down. How do I do that?