Make cell variable when referencing it in cell function

[undergraduate]

Hi, this is a very simple question, but i am somewhat stumped.

Please Login or Register  to view this content.

Vdata here is a variable. I would like A2 to also be variable, so that when the active cell is on C3 it is referring to A3 for the formula. Wondering the best way to go about this. I was thinking maybe using RC[-2] but that hasn't been working.

[mikerickson]

If you want the final formula to reference column A of the cell holding the formula:

ActiveCell.FormulaR1C1 = vData & "/" & RC1 & "_all_" & vData & ".xls"

If you want the contents of colA of the current row to be put into the formula

Please Login or Register  to view this content.

Looking at the string that's being built, it looks like you are changing the cell's .Value rather than its .Formula.

[undergraduate]

thanks so much sir, that worked very nicely