Hi
In the sheet named Data, cell A1 contains the formula =count(B:B)+1
I'm trying to write a code that change the reference of cell A1 in the sheet named Result. The refernce should be =C???, where ??? is the result from A1 from Data.
My code look like:
Could anyone help me?
In the sheet named Data, cell A1 contains the formula =count(B:B)+1
I'm trying to write a code that change the reference of cell A1 in the sheet named Result. The refernce should be =C???, where ??? is the result from A1 from Data.
My code look like:
Code:
Sub Reference()
Sheets("Result").Select
ActiveCell.FormulaR1C1 = "='Data'!R[ ???? ]C[1]"
End Sub
Could anyone help me?