PDA

View Full Version : Solved: filling a column with formulae



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.

xld
01-12-2008, 05:35 AM
ActiveSheet.Columns(10).FormulaR1C1 = "=RC[-1]"


as an example