Fill down Formula Automatically

S

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?
 
J

Jacob Skaria

Hi Shon

Try the below

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


If this post helps click Yes
 
A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top