I need to copy a formula, just as it is from one cell to another; I don't know how to make it continual down the page. For example, I copy the formula from A1 to A2; I do not know how to continue the function to B1 to B2 and so and so forth.
This is how it looks for one copy paste now
[VBA] Sub Copy()
Range("BC9").Select
ActiveCell.FormulaR1C1 = "=SUM('Source Data'!R[24]C[-33])"
Range("T9").Select
ActiveCell.FormulaR1C1 = "=SUM('Source Data'!R[24]C[2])"
Range("AV9").Select
End Sub[/VBA]