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.
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.
[vba]
ActiveSheet.Columns(10).FormulaR1C1 = "=RC[-1]"
[/vba]
as an example
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber