how to refer to cell with variable in a formula?

[seb]

Hello,

I want to refer to an area of cell in a column to calculate the average value in a macro. My problem is that the length of the area has to change depending of the data contains in the document. I would like to write something like this:

ActiveCell.FormulaR1C1 = "=AVERAGE(R[Start%]C:R[end%]C)"

but unfortunatly it doesn't work. have you any idea?

Thanks

[starryknight64]

Try something like this:

Please Login or Register  to view this content.

Only in your case, start and end need to change and not be static values.
I hope this helps!

[seb]

Thank for your response, I use your notation with an interger and it works...