dynamic autofill issue

[excel_2009]

hi excel gurus, i am having difficulty and was wondeirng if someone can help

i have the following table

A | B | C
1 3
3 3
4 1
5 5

and i wish for column C to contain the formula of A2+B2, however i want it assigned to a macro/vba coding so that when the button is pressed the formula is dragged down, however the number of rows from A/B will vary on a daily basis

can someone help ??

 

[VoG]

Try

Sub test()
Dim LR As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
Range("C2:C" & LR).Formula = "=A2+B2"
End Sub

 

[Sektor]

[COLOR="Blue"]Sub[/COLOR] SetFormula()
    Range("C2:C" & Range("A1").End(xlDown).Row).FormulaR1C1 = "=RC[-2]+RC[-1]"
[COLOR="Blue"]End[/COLOR] [COLOR="Blue"]Sub[/COLOR]

 

[excel_2009]

Thank you Vog & Sektor!

Both methods work perfectly!!!

 

[Sektor]

Very good!