Fill down Formula Automatically

[Shon]

Can I automate filling down a formula e.g.

if I have to formulas a1+b1 and answer is in c1 I then want the next formula
to calculate a2+b2 and put answer in c2 and repeat this down 20 rows. I
currently have to put the formula in manually as the cells references
containing the data may change sometimes

Any ideas?

 

[Jacob Skaria]

Hi Shon

Try the below

Range("C1:C20").Formula ="=A1+B1"


If this post helps click Yes

 

[Aussie Bob C]

Use "FillDownC" if your changing data in columns A & B should increase or
decrease in rows.

Sub FillDownC()

With Range("C1")
.Formula = "=A1+B1"
.AutoFill Destination:=Range("C1:C" & Range("A10000").End(xlUp).Row)
End With

End Sub

--
Thank you

Aussie Bob C
Little cost to carry knowledge with you.
Win XP P3 Office 2007 on Mini Mac using VMware.