Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding two columns ...please help
Hi,
I have numbers in Column B and C. I need to see the value of =SUM(B1:C1) that will appear in cell D1. the value of SUM(B2:C2) that will appear in D2,the value of SUM(B3:C3) that will appear in cell D3. up to the end. I can do it in VBS but I need to know the way to see SUM(B1:C1) in the Fx window when I'll click on the cell D1 when it's generated by vbs I don't know how to code it. Thanks. Joe |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding two columns ...please help
Jack
Maybe this? Sub Auto_Fill() Dim Lrow As Long With ActiveSheet Range("D1").Formula = "=B1+C1" Lrow = Range("C" & Rows.Count).End(xlUp).Row Range("D1:D" & Lrow).FillDown End With End Sub Gord Dibben MS Excel MVP On Thu, 14 Jun 2007 11:46:01 -0700, Jack wrote: Hi, I have numbers in Column B and C. I need to see the value of =SUM(B1:C1) that will appear in cell D1. the value of SUM(B2:C2) that will appear in D2,the value of SUM(B3:C3) that will appear in cell D3. up to the end. I can do it in VBS but I need to know the way to see SUM(B1:C1) in the Fx window when I'll click on the cell D1 when it's generated by vbs I don't know how to code it. Thanks. Joe |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding two columns ...please help
Thanks Gord!!!!!!!!!!
"Gord Dibben" wrote: Jack Maybe this? Sub Auto_Fill() Dim Lrow As Long With ActiveSheet Range("D1").Formula = "=B1+C1" Lrow = Range("C" & Rows.Count).End(xlUp).Row Range("D1:D" & Lrow).FillDown End With End Sub Gord Dibben MS Excel MVP On Thu, 14 Jun 2007 11:46:01 -0700, Jack wrote: Hi, I have numbers in Column B and C. I need to see the value of =SUM(B1:C1) that will appear in cell D1. the value of SUM(B2:C2) that will appear in D2,the value of SUM(B3:C3) that will appear in cell D3. up to the end. I can do it in VBS but I need to know the way to see SUM(B1:C1) in the Fx window when I'll click on the cell D1 when it's generated by vbs I don't know how to code it. Thanks. Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding columns | New Users to Excel | |||
Adding columns | Excel Discussion (Misc queries) | |||
Adding Columns, Then deleting old columns | Excel Discussion (Misc queries) | |||
adding 2 columns where | Excel Discussion (Misc queries) | |||
adding columns | Excel Programming |