Can someone please explain to me how to create a vlookup formula using Activecell.FormulaR1C1 in VBA? BUT using "$A$1:$B$33" style instead of R1C1, as I need the range to stay absolute instead of relative. The R1C1 formula in VBA is always relative to the activecell location. For example the following does not work in VBA. "Merchant list" is the sheet of reference:

ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC3,'Merchant List'!" "$A$2:$B$22" & ",3,False)"

I want the cell of reference RC3 to stay relative, but the lookup table "A2:B22" to stay absolute.

Thanks,

J