When recording a macro some of my instruction have RANGE to reference an cell locate that I want to modify with a macro. GOOD Example below: This is how I want my macro to identify the specific cell.

Range("B1").Select

    ActiveCell.FormulaR1C1 = "Team Name"
My problem is some how ?Active Cell? is being used and that?s not what I want. How can I disable the Active Cell reference and just stick to RANGE.

Bad Example:

ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],Teamlist,2)"

    Range("C106").Select


I have looked at TOOLS, OPTIONS, General Tab, for the R1C1 reference settings and it is not checked.



Any help?



Mike in Wisconsin