Macro Sum of Cells

[herve]

Hello all,
could someone help me to write a Macro :

I Have Numbers in Cells B12 to B?? (Variable) & Cells C12 to
C??(Variable)
In Cells D12 to D?? (to the last one), I want to do the sum of the
respective B+C Cells.

For Example,
D12 = B12 + C12
.....
.....
D20 = B20 + C20
.....

Thanks in Advance

 

[Mike Mertes]

Sounds like you'd be best off with in cell operations. Did you try adding
them right in the D column? Like D12: '=B12+C12', then copying that formula
down the rows. Or did you want that it should be automated/callable and
result in raw values? (Hence the 'Macro'...)

 

[herve]

Thanks Mike, but would prefer to do it by macro,
First, select the last B and C cell and after, do the sum.
Regards

 

[Bob Phillips]

For i = 12 To Cells(Rows.Count).End(xlUp).Row
Cells(i,"D").Formula = "=B" & i & "+C" & i
Next i

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[herve]

Hi bob,
that macro seems not working.
Regards
Herve

 

[Dave Peterson]

One more based on Bob's response:

range("d12:d" & cells(rows.count,"B").end(xlup).row).Formula = "=B12+c12"