In VBA, I understand the difference between the sheet codename, sheet name, and sheet index number and how to use those differences in VBA, but can't quite figure out how to use the codename in the formula.
.FormulaR1C1 = "=VLOOKUP(RC25,Sheet1!C[-65]:C[-64],2,FALSE)"
Sheet1 is the sheet name...