philfer
01-12-2008, 04:58 AM
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.
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.