VLOOKUP ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-3],C[-2],1,FALSE)"

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nicolenwn
    New Member
    • Nov 2009
    • 23

    VLOOKUP ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-3],C[-2],1,FALSE)"

    Hello(:

    Can any help explain this line of code (Just a sample code):
    ActiveCell.Form ulaR1C1 = "=VLOOKUP(R C[-3],C[-2],1,FALSE)"

    It is used in Excel VBA. What does RC means and which cell is it referring to?

    Any help is appreciated! Thanks(:
Working...