Solved: filling a column with formulae

[philfer]

Hi,

I want to fill down an entire column with a formula in VBA is there a way to do this easily. I use Activesheet.Cells(i,10).FormulaR1C1 = "etc" to input my formula but then want it to be in the whole column.

[Bob Phillips]

ActiveSheet.Columns(10).FormulaR1C1 = "=RC[-1]"


as an example