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


--
herve
------------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=481834

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" wrote in
message ...

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


--
herve
------------------------------------------------------------------------
herve's Profile:
http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=481834

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)


"Mike Mertes" wrote in message
...
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" wrote in
message ...

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


--
herve
------------------------------------------------------------------------
herve's Profile:
http://www.excelforum.com/member.php...o&userid=27314
View this thread:
http://www.excelforum.com/showthread...hreadid=481834

Hi bob,
that macro seems not working.
Regards
Herve


--
herve
------------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=481834

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


--
herve
------------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=481834

One more based on Bob's response:

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

herve wrote:

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

--
herve
------------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=481834

--

Dave Peterson